:10141;2000;"Star Trek: Voyager: Season 7"

:10141;2000;"Star Trek: Voyager: Season 7"

#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!)  

#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!)  

#:select year, count(*) from movie where year >=1940 and year <1950 group by year order by year

#*select year, count(*) from movie where year >=1940 and year <1950 group by year order by year

:1940;34

:1940;34

:1941;33

:1941;33

:1949;41

:1949;41

#Which movies, in alphabetical order, did member number 42 rate as a “5”?  

#Which movies, in alphabetical order, did member number 42 rate as a “5”?  

#:select * from movie inner join rating on (rating.movie = movie.id) where member = 42 and rating = 5 order by title

#*select * from movie inner join rating on (rating.movie = movie.id) where member = 42 and rating = 5 order by title

:113;2000;"Bruce Lee: A Warrior's Journey";113;42;5

:113;2000;"Bruce Lee: A Warrior's Journey";113;42;5

:13847;2001;"Donnie Darko: Director's Cut";13847;42;5

:13847;2001;"Donnie Darko: Director's Cut";13847;42;5

:37;1973;"Zatoichi's Conspiracy";37;42;5

:37;1973;"Zatoichi's Conspiracy";37;42;5

#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.  

#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.  

#:select *, rating from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member)  

#*select *, rating from movie inner join rating on (movie.id = rating.movie) inner join member on (member.id = rating.member)  

:30;2003;"Something's Gotta Give";30;42;4;42;"Doug";4

:30;2003;"Something's Gotta Give";30;42;4;42;"Doug";4

:37;1973;"Zatoichi's Conspiracy";37;6;4;6;"Natalie";4

:37;1973;"Zatoichi's Conspiracy";37;6;4;6;"Natalie";4

:5;4

:5;4

#What is the average rating of movies that begin with the word “Star”?  

#What is the average rating of movies that begin with the word “Star”?