Ajvree Week 6 - Revision history

Ajvree: question 9

2013-10-04T01:18:24Z

question 9

Ajvree: change on 3

2013-10-04T01:13:01Z

change on 3

Ajvree: formatting

2013-10-04T01:12:08Z

formatting

Ajvree at 19:06, 3 October 2013

2013-10-03T19:06:32Z

@@ Line 39: / Line 39: @@
 '''7.Produce a table that lists every movie that has been rated, the rating that the movie got, and the name of the member that gave this rating.'''
 '''8.How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?'''<br>
@@ Line 49: / Line 50: @@
 '''9.What is the average rating of movies that begin with the word “Star”?'''
 '''10.Form your own query involving movies, ratings, and members, then

@@ Line 8: / Line 8: @@
 '''3.What movies have apostrophes in their titles?'''<br>
-select * from movie where title like '%''%'<br>
+select * from movie where title like '%'%'<br>
 There were many results, count 1280

@@ Line 1: / Line 1: @@
-.What movies were released before 1915?<br>
+'''1.What movies were released before 1915?'''<br>
 select * from movie where year < 1915<br>
 DW Griffith, Lumiere Brother.., Tillie's Punctu.., Cabiria
-.What movies from the 1980s had 4-digit numbers in their titles?
+'''2.What movies from the 1980s had 4-digit numbers in their titles?'''
 select * from movie where title ~ '[0123456789][012356789][0123456789][0123456789]' and year >= 1980 and year < 1990<br>
 Cherry 2000, 2010: The Year.., 1984, Cold Summer of.., Butthole Surfers.., Gundam 0080.., Transylvania 6.., Hong Kong 1941, 1969, Mystery Science.., Eric Clapton.., the 2000 year..., Teenage Mutant..
-.What movies have apostrophes in their titles?<br>
+'''3.What movies have apostrophes in their titles?'''<br>
 select * from movie where title like '%''%'<br>
 There were many results, count 1280
-.How many movies have titles that begin with the word “Star”?<br>
+'''4.How many movies have titles that begin with the word “Star”?'''<br>
 select count(*) from movie where title ~ '^Star'<br>
 results
-.How many movies, on a year by year basis, were released in the 1940s (years 1940 to 1949)? (don’t answer this question by listing the movies then counting the results!)<br>
+'''5.How many movies, on a year by year basis, were released in the 1940s (years 1940 to 1949)? (don’t answer this question by listing the movies then counting the results!)'''<br>
 select year, count(*) from movie where year > 1940 and year < 1950 group by year<br>
 - 33<br>
@@ Line 30: / Line 30: @@
-.Which movies, in alphabetical order, did member number 42 rate as a “5”?<br>
+'''6.Which movies, in alphabetical order, did member number 42 rate as a “5”?'''<br>
 select title, rating from movie inner join rating on (movie.id = rating.movie) where member = 42 and rating = 5 order by title<br>
 Bruce Lee A Warriors Journey<br>
@@ Line 38: / Line 38: @@
-.Produce a table that lists every movie that has been rated, the rating that the movie got, and the name of the member that gave this rating.
+'''7.Produce a table that lists every movie that has been rated, the rating that the movie got, and the name of the member that gave this rating.'''
-.How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?<br>
+'''8.How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?'''<br>
 select title, rating from movie inner join rating on (movie.id = rating.movie) where member = 42 order by rating<br>
 -1<br>
@@ Line 48: / Line 48: @@
 -4<br>
-.What is the average rating of movies that begin with the word “Star”?
+'''9.What is the average rating of movies that begin with the word “Star”?'''
-.Form your own query involving movies, ratings, and members, then
+'''10.Form your own query involving movies, ratings, and members, then
-State your query in plain English (like the queries above).
+State your query in plain English (like the queries above).'''
-Provide the SQL query "translation" of your plain English query.
+'''Provide the SQL query "translation" of your plain English query.'''
-Supply the answer to your query, according to the sample movie database.
+'''Supply the answer to your query, according to the sample movie database.'''

@@ Line 40: / Line 40: @@
 .Produce a table that lists every movie that has been rated, the rating that the movie got, and the name of the member that gave this rating.
-.How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?
+.How many movies has member number 42 rated as 1, 2, 3, 4, and 5, respectively?<br>
 .What is the average rating of movies that begin with the word “Star”?