Difference between revisions of "Mpetredi Week 6"
From LMU BioDB 2013
(added answer 8) |
(→Movies from Text File to Tables: added some answers to week 6 individual assignment) |
||
| Line 5: | Line 5: | ||
#*9103;1914;"Tillie's Punctured Romance" | #*9103;1914;"Tillie's Punctured Romance" | ||
#*10898;1914;"Cabiria" | #*10898;1914;"Cabiria" | ||
| − | # | + | #select * from movie where year > 1979 and year < 1990 and title ~ '[0123456789][0123456789][0123456789][0123456789]' |
| − | # | + | #*217;1988;"Cherry 2000" |
| + | #*1163;1984;"2010: The Year We Make Contact" | ||
| + | #*1399;1984;"1984" | ||
| + | #*1480;1988;"Cold Summer of 1953" | ||
| + | #*4882;1985;"Butthole Surfers: Blind Eye See All: Live 1985" | ||
| + | #*5482;1989;"Gundam 0080: War in the Pocket" | ||
| + | #*5890;1985;"Transylvania 6-5000" | ||
| + | #*7725;1984;"Hong Kong 1941" | ||
| + | #*15128;1988;"1969" | ||
| + | #*15269;1989;"Mystery Science Theater 3000: The Crawling Hand" | ||
| + | #*15390;1987;"Eric Clapton & Friends: Live 1986" | ||
| + | #*16985;1982;"The 2000 Year Old Man" | ||
| + | #*17007;1987;"Teenage Mutant Ninja Turtles (1980s)" | ||
| + | # select * from movie where title ~ '''' | ||
| + | #*4;1994;"Paula Abdul's Get Up & Dance" | ||
| + | #*9;1991;"Class of Nuke 'Em High 2" | ||
| + | #*19;2000;"By Dawn's Early Light" | ||
| + | #*23;2001;"Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo" | ||
| + | #*27;1962;"Sesame Street: Elmo's World: The Street We Live On" | ||
| + | #*30;2003;"Something's Gotta Give" | ||
| + | #*32;2004;"ABC Primetime: Mel Gibson's The Passion of the Christ" | ||
| + | #*34;2003;"Ashtanga Yoga: Beginner's Practice with Nicki Doane" | ||
| + | #*37;1973;"Zatoichi's Conspiracy" | ||
| + | #*54;1952;"We're Not Married" | ||
| + | |||
| + | |||
#select count(*) from movie where title ~ '^Star ' | #select count(*) from movie where title ~ '^Star ' | ||
#*61 | #*61 | ||
Revision as of 20:20, 3 October 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 * from movie where year > 1979 and year < 1990 and title ~ '[0123456789][0123456789][0123456789][0123456789]'
- 217;1988;"Cherry 2000"
- 1163;1984;"2010: The Year We Make Contact"
- 1399;1984;"1984"
- 1480;1988;"Cold Summer of 1953"
- 4882;1985;"Butthole Surfers: Blind Eye See All: Live 1985"
- 5482;1989;"Gundam 0080: War in the Pocket"
- 5890;1985;"Transylvania 6-5000"
- 7725;1984;"Hong Kong 1941"
- 15128;1988;"1969"
- 15269;1989;"Mystery Science Theater 3000: The Crawling Hand"
- 15390;1987;"Eric Clapton & Friends: Live 1986"
- 16985;1982;"The 2000 Year Old Man"
- 17007;1987;"Teenage Mutant Ninja Turtles (1980s)"
- select * from movie where title ~ '
- 4;1994;"Paula Abdul's Get Up & Dance"
- 9;1991;"Class of Nuke 'Em High 2"
- 19;2000;"By Dawn's Early Light"
- 23;2001;"Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo"
- 27;1962;"Sesame Street: Elmo's World: The Street We Live On"
- 30;2003;"Something's Gotta Give"
- 32;2004;"ABC Primetime: Mel Gibson's The Passion of the Christ"
- 34;2003;"Ashtanga Yoga: Beginner's Practice with Nicki Doane"
- 37;1973;"Zatoichi's Conspiracy"
- 54;1952;"We're Not Married"
- 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
