Gleis Week 6

Movies from Text File to Tables

1. select * from movie where year < 1915
   • "D.W. Griffith: Years of Discovery 1909-1913" "Lumiere Brothers' First Films"
   • Tillie's Punctured Romance" "Cabiria"
2. select title from movie where title ~ '[0123456789][0123456789][0123456789][0123456789]' and year >= 1980 and year < 1990
   • "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)"
3. select title from movie where title ~ '
   • "Paula Abdul's Get Up & Dance"
   • "Class of Nuke 'Em High 2"
   • "By Dawn's Early Light"
   • "Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo"
   • "Sesame Street: Elmo's World: The Street We Live On"
   • "Something's Gotta Give"
   • "ABC Primetime: Mel Gibson's The Passion of the Christ"
   • "Ashtanga Yoga: Beginner's Practice with Nicki Doane"
   • "Zatoichi's Conspiracy"
   • "We're Not Married"