# one column
CREATE numbers 1 int digit
CREATE numbers 1 string num
INSERT INTO numbers 4 ROWS
2
8
5
7
INSERT INTO digits 4 ROWS
1
4
6
2
DELETE FROM digits WHERE digit = 5
DELETE FROM numbers WHERE digit = 2
GENERATE FOR digits bst INDEX on num
GENERATE FOR numbers hash INDEX on digit
FAKE command
PRINT FROM numbers 1 name WHERE num = 47
PRINT FROM digits 1 name WHERE num = 2
PRINT FROM digits 1 age WHERE name = bob
JOIN numbers AND numbers WHERE digit = digit AND PRINT 1 digit 1
JOIN numbers AND digit WHERE digit = num AND PRINT 1 num 1
JOIN numbers AND numbers WHERE num = num AND PRINT 1 num 1
CREATE digits 1 int numeric
JOIN numbers AND digit WHERE digit = numeric AND PRINT 1 num 1
REMOVE digit
REMOVE digits
QUIT