### 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