Kevinmcgee Week 6

Movies from Text Titles to Tables

1. select * from movie where year < 1915
   • "D.W. Griffith: Years of Discovery 1909-1913"
   • "Lumiere Brothers' First Films"
   • "Tillie's Punctured Romance"
   • "Cabiria"
2. select * from movie where year >1979 and year <1990 and title ~ '[0123456789][0123456789][0123456789][0123456789]'
   • 1988;"Cherry 2000"
   • 1984;"2010: The Year We Make Contact"
   • 1984;"1984"
   • 1988;"Cold Summer of 1953"
   • 1985;"Butthole Surfers: Blind Eye See All: Live 1985"
   • 1989;"Gundam 0080: War in the Pocket"
   • 1985;"Transylvania 6-5000"
   • 1984;"Hong Kong 1941"
   • 1988;"1969"
   • 1989;"Mystery Science Theater 3000: The Crawling Hand"
   • 1987;"Eric Clapton & Friends: Live 1986"
   • 1982;"The 2000 Year Old Man"
   • 1987;"Teenage Mutant Ninja Turtles (1980s)"

4select count (*) from movie where title ~ '^Star '

• 61

6 select * from movie inner join rating on (rating.movie = movie.id) where member = 42 and rating = 5

• 113;2000;"Bruce Lee: A Warrior's Journey";113;42;5

37;1973;"Zatoichi's Conspiracy";37;42;5 4765;1998;"The Legend of Zelda: Ganon's Evil Tower";4765;42;5 13847;2001;"Donnie Darko: Director's Cut";13847;42;5