Lena Week 6

1.) What movies were released before 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)"

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”?