Revision as of 01:22, 4 October 2013

Movies from Text File to Tables

What movies were released before 1915?

Query

select * from movie where year < 1915

Output

4975;1909;"D.W. Griffith: Years of Discovery 1909-1913"
7654;1896;"Lumiere Brothers' First Films"
9103;1914;"Tillie's Punctured Romance"
10898;1914;"Cabiria"

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

Query

select * from movie where title ~ '

Output

4;1994;"Paula Abdul's Get Up & Dance"
9;1991;"Class of Nuke 'Em High 2"
19;2000;"By Dawn's Early Light"
23;2001;"Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo"
27;1962;"Sesame Street: Elmo's World: The Street We Live On"
30;2003;"Something's Gotta Give"
32;2004;"ABC Primetime: Mel Gibson's The Passion of the Christ"
34;2003;"Ashtanga Yoga: Beginner's Practice with Nicki Doane"
37;1973;"Zatoichi's Conspiracy"
54;1952;"We're Not Married"