Lena Week 6

1.) What movies were released before 1915?

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?

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.)What movies have apostrophes in their titles?

select * from movie where title ~

"Dinosaur Planet"

"Isle of Man TT 2004 Review" "Character" "Paula Abdul's Get Up & Dance" "The Rise and Fall of ECW" "Sick" "8 Man" "What the #$*! Do We Know!?" "Class of Nuke 'Em High 2" "Fighter"

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

61 movies.

5.) How many movies, on a year by year basis, were released in the 1940s (years 1940 to 1949)?

There are 359 from the 1940s. 34 from 1940, 33 from 1941, 33 from 1942, 33 from 1943, 36 from 1944, 37 from 1945, 39 from 1946, 37 from 1947, 38 from 1948, and 41 from 1949.

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