#Lots of remove, duplicates
CREATE friends 5 string string bool int string name vibe is_cool distance town
INSERT INTO friends 10 ROWS
Bri Fun false 100 Ann_Arbor
Jack Edgy true 1000 Ann_Arbor
Brian Smart true 1000 Ann_Arbor
Abby Loud false 10 Ann_Arbor
Ben Scary false 10000 Los_Angeles
Bri Fun false 100 Ann_Arbor
Jack Edgy true 1000 Ann_Arbor
Brian Smart true 999 Ann_Arbor
Abby Loud false 10 Ann_Arbor
Ben Scary false 10000 Los_Angeles
PRINT FROM friends 3 name vibe town ALL
GENERATE FOR friends hash INDEX ON distance
PRINT FROM friends 3 name vibe town ALL
DELETE FROM friends WHERE name = Bri
PRINT FROM friends 3 name vibe town WHERE is_cool = true
DELETE FROM friends WHERE name = Ben
PRINT FROM friends 3 name vibe town ALL
DELETE FROM friends WHERE name = Abby
PRINT FROM friends 3 name distance town WHERE vibe = Fun
PRINT FROM friends 3 name distance town WHERE vibe = Smart
PRINT FROM friends 3 name distance town WHERE vibe = Ann_Arbor
CREATE work 3 string bool bool kind working done
INSERT INTO work 3 ROWS
Coding true false
Serving false true
Crying true false
GENERATE FOR work bst INDEX ON done
JOIN friends AND work WHERE is_cool = working AND PRINT 3 Name 1 kind 2 town 1
DELETE FROM work WHERE kind = Serving
DELETE FROM work WHERE kind = Crying
GENERATE FOR friends bst INDEX ON town
GENERATE FOR friends bst INDEX ON distance
GENERATE FOR friends bst INDEX ON name
PRINT FROM friends 3 name distance town ALL
PRINT FROM work 2 kind working WHERE working = true
REMOVE friends
REMOVE work
QUIT