Difference between revisions of "Mpetredi Week 6"
From LMU BioDB 2013
(answered question 4) |
(added answer 8) |
||
| Line 10: | Line 10: | ||
#*61 | #*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 | ||
Revision as of 17:29, 26 September 2013
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
