Kmeilak Week 6

Movies from Text File to Tables

1. What movies were released before 1915?

• "D.W. Griffith: Years of Discovery 1909-1913"
• "Lumiere Brothers' First Films"
• "Tillie's Punctured Romance"
• "Cabiria"

command

select * from movie where year < 1915;

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

• "Cherry 2000"
• "2010: The Year We Make Contact"
• "1984"
• "Cold Summer of 1953"
• "Butthole Surfers: Blind Eye See All: Live 1985"
• "Transylvania 6-5000"
• "Hong Kong 1941"
• "1969"
• "Eric Clapton & Friends: Live 1986"
• "The 2000 Year Old Man"
• "Teenage Mutant Ninja Turtles (1980s)"

command

select * from movie where (year >= 1980 and year < 1989) and title ~ '[0123456789][0123456789][0123456789][0123456789]';