Difference between revisions of "Ksherbina Week 6"
From LMU BioDB 2013
(Changed a comment from a comment to the answer to question 1. Added the output for question 1.) |
(Added code and output for #2.) |
||
| Line 11: | Line 11: | ||
9103;1914;"Tillie's Punctured Romance" | 9103;1914;"Tillie's Punctured Romance" | ||
10898;1914;"Cabiria" | 10898;1914;"Cabiria" | ||
| + | |||
| + | 2. Code: | ||
| + | select * from movie where year > 1979 and year < 1990 and title ~ '[0-9][0-9][0-9][0-9]' | ||
| + | |||
| + | :Output: | ||
| + | 217;1988;"Cherry 2000" | ||
| + | 1163;1984;"2010: The Year We Make Contact" | ||
| + | 1399;1984;"1984" | ||
| + | 1480;1988;"Cold Summer of 1953" | ||
| + | 4882;1985;"Butthole Surfers: Blind Eye See All: Live 1985" | ||
| + | 5482;1989;"Gundam 0080: War in the Pocket" | ||
| + | 5890;1985;"Transylvania 6-5000" | ||
| + | 7725;1984;"Hong Kong 1941" | ||
| + | 15128;1988;"1969" | ||
| + | 15269;1989;"Mystery Science Theater 3000: The Crawling Hand" | ||
| + | 15390;1987;"Eric Clapton & Friends: Live 1986" | ||
| + | 16985;1982;"The 2000 Year Old Man" | ||
| + | 17007;1987;"Teenage Mutant Ninja Turtles (1980s)" | ||
<!-- 3. Code: select * from movie where title ~ '''' --> | <!-- 3. Code: select * from movie where title ~ '''' --> | ||
Revision as of 01:39, 4 October 2013
| Assignment Description | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 15 |
| Class Journal | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | |||||
| Individual Journal | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 |
| Other | Week 5: Database Wiki |
| Final Project | Team H(oo)KD Project Page | Journal Club Presentation | Project Individual Journal |
Movies from Text Files to Tables
1. Code:
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"
2. Code:
select * from movie where year > 1979 and year < 1990 and title ~ '[0-9][0-9][0-9][0-9]'
- Output:
217;1988;"Cherry 2000" 1163;1984;"2010: The Year We Make Contact" 1399;1984;"1984" 1480;1988;"Cold Summer of 1953" 4882;1985;"Butthole Surfers: Blind Eye See All: Live 1985" 5482;1989;"Gundam 0080: War in the Pocket" 5890;1985;"Transylvania 6-5000" 7725;1984;"Hong Kong 1941" 15128;1988;"1969" 15269;1989;"Mystery Science Theater 3000: The Crawling Hand" 15390;1987;"Eric Clapton & Friends: Live 1986" 16985;1982;"The 2000 Year Old Man" 17007;1987;"Teenage Mutant Ninja Turtles (1980s)"
