CREATE pals 4 string bool int double name likes_pizza distance lies_told
# no comment at top
INSERT INTO pals 3 ROWS
tyler false 100 32.5
izzy false 1000 84.21
sam true 3231 423.32
PRINT FROM pals 3 name likes_pizza distance WHERE age < 20
INSERT INTO pals 2 ROWS
mom true 10000 0
dad false 300 21
zak true 10 32.1
GENERATE FOR friends hash INDEX ON distance
GENERATE FOR pals bst INDEX ON lies_told
PRINT FROM pals 3 likes_pizza distance ALL
GENERATE FOR friends hash INDEX ON lies_told
PRINT FROM pals 3 likes_pizza lies_told WHERE likes_pizza = true
GENERATE FOR pals hash INDEX ON lies_told
PRINT FROM pals 3 likes_pizza name distance WHERE distance > 0
INSERT INTO pals4 1 ROWS
brian true 0 2
PRINT FROM pals 3 likes_pizza name WHERE likes_pop = true
DELETE FROM pals WHERE name = brian
PRINT FROM pals 1 name ALL
INSERT INTO pals 2 ROWS
leo true 10 2.1
noah true true 500.20
PRINT FROM pals 3 name likes_pizza WHERE name = leo
PRINT FROM pals 1 distance WHERE distance > 1
REMOVE friends
REMOVE pals
REMOVE pals
QUIT