ITM 500 Study Guide - Midterm Guide: Oricon
Document Summary
1. list the titles of all movie of the comedy type. Select * from movie where mvtype = comedy". -2. list the details of all movies with more than 3 nominations . sequence by title. Select * from movie where nom > 3 order by mvtitle. -3. list star details in name order for stars appearing in movie with the character string "alien" anywhere in title select star. * from star inner join role on star. starnumb = role. starnumb inner join movie on role. mvnumb = movie. mvnumb where mvtitle like "%alien%" order by starname. -4. list names of directors that have directed a horror movie. show each director only once. *, movietype from movie where movietype like horror". -5. list details of movies that have between 5 and 20 nominations. sequence by title within type select * from movie where nominations between 5 and 20 order by mvtype, mvtitle.