# What movies were released before 1915?

# What movies were released before 1915?

#*select * from movie where year < 1915

#*select * from movie where year < 1915

#*

#*movie id; year; title

#*#4975;1909;"D.W. Griffith: Years of Discovery 1909-1913"

#*#4975;1909;"D.W. Griffith: Years of Discovery 1909-1913"

#*#7654;1896;"Lumiere Brothers' First Films"

#*#7654;1896;"Lumiere Brothers' First Films"

#*#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?

# 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]'

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

#*

#*movie id; year; title

#*#217;1988;"Cherry 2000"

#*#217;1988;"Cherry 2000"

#*#1163;1984;"2010: The Year We Make Contact"

#*#1163;1984;"2010: The Year We Make Contact"

#*#16985;1982;"The 2000 Year Old Man"

#*#16985;1982;"The 2000 Year Old Man"

#*#17007;1987;"Teenage Mutant Ninja Turtles (1980s)"

#*#17007;1987;"Teenage Mutant Ninja Turtles (1980s)"

# What movies have apostrophes in their titles?

# What movies have apostrophes in their titles?

#*select * from movie where title ~ ''''

#*select * from movie where title ~ ''''

#*

#*movie id; year; title

#*#4;1994;"Paula Abdul's Get Up & Dance"

#*#4;1994;"Paula Abdul's Get Up & Dance"

#*#9;1991;"Class of Nuke 'Em High 2"

#*#9;1991;"Class of Nuke 'Em High 2"

#*#248;2001;"Michael Moore's The Awful Truth: Season 2"

#*#248;2001;"Michael Moore's The Awful Truth: Season 2"

#*#251;2000;"Midsomer Murders: Strangler's Wood"

#*#251;2000;"Midsomer Murders: Strangler's Wood"

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

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

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

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

#*#88

#**88

 

# How many movies, on a year by year basis, were released in the 1940s (years 1940 to 1949)?  (''don’t'' answer this question by listing the movies then counting the results!)

# How many movies, on a year by year basis, were released in the 1940s (years 1940 to 1949)?  (''don’t'' answer this question by listing the movies then counting the results!)

#*select count(*) from movie where year > 1939 and year < 1950

#*select count(*) from movie where year > 1939 and year < 1950

#*#359

#**359

#*select count(*) from movie where year = 1940

#*select count(*) from movie where year = 1940

#*#34

#**34

#*select count(*) from movie where year = 1941

#*select count(*) from movie where year = 1941

#*#33

#**33

#*select count(*) from movie where year = 1942

#*select count(*) from movie where year = 1942

#*#33

#**33

#*select count(*) from movie where year = 1943

#*select count(*) from movie where year = 1943

#*#33

#**33

#*select count(*) from movie where year = 1944

#*select count(*) from movie where year = 1944

#*#36

#**36

#*select count(*) from movie where year = 1945

#*select count(*) from movie where year = 1945

#*#37

#**37

#*select count(*) from movie where year = 1946

#*select count(*) from movie where year = 1946

#*#39

#**39

#*select count(*) from movie where year = 1947

#*select count(*) from movie where year = 1947

#*#37

#**37

#*select count(*) from movie where year = 1948

#*select count(*) from movie where year = 1948

#*#36

#**36

#*select count(*) from movie where year = 1949

#*select count(*) from movie where year = 1949

#*#41

#**41

 

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

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