Ajvree Week 6

1.What movies were released before 1915? select * from movie < 1915

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

3.What movies have apostrophes in their titles?
select * from movie where title like '%%'
There were many results, count 1280

4.How many movies have titles that begin with the word “Star”?
select count(*) from movie where title ~ '^Star'
88 results

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! ) 6.Which movies, in alphabetical order, did member number 42 rate as a “5”?

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?

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 State your query in plain English (like the queries above).

Provide the SQL query "translation" of your plain English query.

Supply the answer to your query, according to the sample movie database.