Laurmagee: Week 6

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 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" 62;1991;"Ken Burns' America: Empire of the Air" 92;2002;"ECW: Cyberslam '99" 113;2000;"Bruce Lee: A Warrior's Journey" 173;1968;"The Devil's Brigade" 202;2001;"Ruby's Bucket of Blood" 215;1998;"That '70s Show: Season 1" 223;2003;"Chappelle's Show: Season 1" 233;1971;"Chato's Land" 248;2001;"Michael Moore's The Awful Truth: Season 2" 251;2000;"Midsomer Murders: Strangler's Wood"

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

88

select * from movie where title ~ '[0123456789][0123456789][0123456789][0123456789]

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