1.What movies were released before 1915?<br>

'''1.What movies were released before 1915?'''<br>

select * from movie where year < 1915<br>

select * from movie where year < 1915<br>

DW Griffith, Lumiere Brother.., Tillie's Punctu.., Cabiria

DW Griffith, Lumiere Brother.., Tillie's Punctu.., Cabiria

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

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

select * from movie where title ~ '[0123456789][012356789][0123456789][0123456789]' and year >= 1980 and year < 1990<br>

select * from movie where title ~ '[0123456789][012356789][0123456789][0123456789]' and year >= 1980 and year < 1990<br>

Cherry 2000, 2010: The Year.., 1984, Cold Summer of.., Butthole Surfers.., Gundam 0080.., Transylvania 6.., Hong Kong 1941, 1969, Mystery Science.., Eric Clapton.., the 2000 year..., Teenage Mutant..

Cherry 2000, 2010: The Year.., 1984, Cold Summer of.., Butthole Surfers.., Gundam 0080.., Transylvania 6.., Hong Kong 1941, 1969, Mystery Science.., Eric Clapton.., the 2000 year..., Teenage Mutant..