Your current SQL expression does not return anything from the current selection because (SELECT MIN( DIRECTIONALITY) FROM TableName) always evaluates to 1, which is indeed the minimum value for the whole table. You need to take the minimum value from just the rows that meet the condition WORKINGSPACE = 'Jeffery' and you can do this in one selection instead ...
CREATE TABLE schema.polytable AS
SELECT column1, column2, ST_AsText(ST_CONVEXHULL(ST_COLLECT(geomcolumn))) AS newgeomcolumn
GROUP BY column1, column2
As suggested by someone else, this works in this scenario.
These eight-digit values are in a column in MapInfo, correct?
If you also have them in one column in NotePad, you can join the two tables where the NotePad values have matches in the MapInfo table; then delete the resulting join/selection from MapInfo.
The a and b are aliases for the nodesData table, you use the alias to refer to the table in the rest of the query. The two queries below are the same except the second uses aliases for the table names.
SELECT Customers.name, Customers.address, Customers.email, tableY.OrderNum, tableY.OrderDate
FROM Customers JOIN Orders ON Customers.CustomerID = tableY....