### begin_: tvshow table
type ;; title ;; fname ;; lname
sitcom ;; simpsons ;; homer ;; simpson
sitcom ;; simpsons ;; ned ;; flanders
sitcom ;; flintstones ;; fred ;; flintstone
sitcom ;; flintstones ;; wilma ;; flintstone
sitcom ;; flintstones ;; barney ;; rubble
gameshow ;; price is right ;; bob ;; barker
gameshow ;; jeopardy ;; alex ;; trebek
####
### begin_: query pseudo-code
TREE_SELECT type,title,fname,lname
FROM tvshow
WITH_LEVEL (1,'type' )
WITH_LEVEL (2,'title' )
WITH_LEVEL (3,'lname','fname' )
WHERE type = 'gameshow'
##
##
gameshow
price is right
barker,bob
jeopardy
trebek,alex