Difference between revisions of "Mpetredi Week 6"
From LMU BioDB 2013
(Answered first question) |
(answered question 4) |
||
| Line 5: | Line 5: | ||
#*9103;1914;"Tillie's Punctured Romance" | #*9103;1914;"Tillie's Punctured Romance" | ||
#*10898;1914;"Cabiria" | #*10898;1914;"Cabiria" | ||
| + | # | ||
| + | # | ||
| + | #select count(*) from movie where title ~ '^Star ' | ||
| + | #*61 | ||
# | # | ||
Revision as of 17:15, 26 September 2013
Movies from Text File to Tables
- select * from movie where year < 1915
- 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"
- select count(*) from movie where title ~ '^Star '
- 61
