Mpetredi Week 6

Movies from Text File to Tables

select * from movie where year < 1915
- 4975;1909;"D.W. Griffith: Years of Discovery 1909-1913"
- 7654;1896;"Lumiere Brothers' First Films"
- 9103;1914;"Tillie's Punctured Romance"
- 10898;1914;"Cabiria"
select count(*) from movie where title ~ '^Star '
- 61
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