This is a subset of the database you'll be using for the midterm. Here are some practice problems:
- Find the name of the movie with the highest average rating.
- Find the genre with the fewest movies for the year 2002.
- Find the movie with the highest number of ratings between 1996 and 2000.
- Find the average number of movie ratings per user.
- Find the years that have a movie from every single genre.
- For each genre, find the number of ratings and average rating.
The tables can be quite large. Below are some links to the table schemas and the results of calling select * from __table__ to save you some time.