CREATE table1 3 bool int double is_fun height weight
INSERT INTO table1 5 ROWS 
false 74 201 
false 543 442 
true 34 34.0
false 15 15
true 1 6.2
JOIN table1 AND table1 WHERE weight = height AND PRINT 2 height 1 weight 2
JOIN table1 AND table1 WHERE weight = weight AND PRINT 2 weight 1 height 1
GENERATE FOR table1 bst INDEX ON height
INSERT INTO table1 3 ROWS
true 1 5.5
true 100 100
false 30 4
PRINT FROM table1 2 is_fun height WHERE weight > 100
PRINT FROM table1 2 is_fun height WHERE weight > 100.0
DELETE FROM table1 WHERE is_fun = true
PRINT FROM table1 1 weight WHERE weight < 100
REMOVE table1
QUIT