# 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"

# 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"

# 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"

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