Taur.vil Week 6

1) Select Movies made before 1915

Code: select title from movie where year < 1915

"D.W. Griffith: Years of Discovery 1909-1913"
"Lumiere Brothers' First Films"
"Tillie's Punctured Romance"
"Cabiria"

2) What movies from the 1980s had 4-digit numbers in their titles?

Code: select * from movie where year > 1979 and year < 1990 and title ~ '[0123456789][0123456789][0123456789][0123456789]'

"Cherry 2000"
"2010: The Year We Make Contact"
"1984"
"Cold Summer of 1953"
"Butthole Surfers: Blind Eye See All: Live 1985"
"Gundam 0080: War in the Pocket"
"Transylvania 6-5000"
"Hong Kong 1941"
"1969"
"Mystery Science Theater 3000: The Crawling Hand"
"Eric Clapton & Friends: Live 1986"
"The 2000 Year Old Man"
"Teenage Mutant Ninja Turtles (1980s)"

3) Select Movies With Apostrophes in the Title

Code: select * from movie where title ~ '

--1280 Results--
"Paula Abdul's Get Up & Dance"
"Class of Nuke 'Em High 2"
"By Dawn's Early Light"
"Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo"
"Sesame Street: Elmo's World: The Street We Live On"
"Something's Gotta Give"
"ABC Primetime: Mel Gibson's The Passion of the Christ"
"Ashtanga Yoga: Beginner's Practice with Nicki Doane"
"Zatoichi's Conspiracy"
"We're Not Married"
"Ken Burns' America: Empire of the Air"
"ECW: Cyberslam '99"
"Bruce Lee: A Warrior's Journey"
"The Devil's Brigade"
"Ruby's Bucket of Blood"
"That '70s Show: Season 1"
"Chappelle's Show: Season 1"
"Chato's Land"
"Michael Moore's The Awful Truth: Season 2"
"Midsomer Murders: Strangler's Wood"

4) How many movies have titles that begin with the word “Star”?

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

61 movies begin with the word Star

5)

6) Which movies, in alphabetical order, did member number 42 rate as a “5”?

Code: select title from movie inner join rating on (movie.id = rating.movie) where member = 42 and rating = 5 order by title

"Bruce Lee: A Warrior's Journey"
"Donnie Darko: Director's Cut"
"The Legend of Zelda: Ganon's Evil Tower"
"Zatoichi's Conspiracy"

Webpage: select name, rating from movie inner join rating on (movie.id = rating.movie) where title like'%%'