Difference between revisions of "Stephen Louie Week 6"
From LMU BioDB 2013
(Created Journal Entry) |
(Edited journal entry) |
||
| Line 1: | Line 1: | ||
=Movies from Text File to Tables= | =Movies from Text File to Tables= | ||
| − | + | ==What movies were released before 1915?== | |
'''Query''' | '''Query''' | ||
select * from movie where year < 1915 | select * from movie where year < 1915 | ||
| Line 8: | Line 8: | ||
9103;1914;"Tillie's Punctured Romance" | 9103;1914;"Tillie's Punctured Romance" | ||
10898;1914;"Cabiria" | 10898;1914;"Cabiria" | ||
| + | ==What movies from the 1980s had 4-digit numbers in their titles?== | ||
| + | '''Query''' | ||
| + | select * from movie where title ~ '''' | ||
| + | '''Output''' | ||
| + | 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" | ||
Revision as of 01:21, 4 October 2013
Movies from Text File to Tables
What movies were released before 1915?
Query
select * from movie where year < 1915
Output
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"
What movies from the 1980s had 4-digit numbers in their titles?
Query select * from movie where title ~ ' Output
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"
