$2$

Complete this on your own. For each problem, take a screenshot to submit.

$1.$ Show movies with their average rating in increasing order.

$2.$ Show all reviewers with their average rating in increasing order.

$3$

$3.$ Repeat the query above, but this time show only average ratings where reviewer name is

empty.

$4.$ Show the movie with its highest rating in descending order.

$5.$ Show movie title, reviewer, director, and rating in ascending order by movie.

$4$

$6.$ Show directors with their average movie rating in alpha order by director.

$7.$ Show the director with the highest average rating.

$8.$ Which directors have movies in multiple genres?

$9.$ Which reviewer gives the highest average ratings?

$5$

$10.$ Show the reviewer$$s name with the number of ratings for the reviewer with the least

number of ratings.