Need some help with some SQL exercises.

## Exercise 1

List the name of the reviewer, the rating and the date for each movie review. Sort by reviewer name.

## Exercise 2

Find the reviews for reviewer 203. Display the movie title, rating and date for all reviews by reviewer 203.

## Exercise 3

Find movies that have not been reviewed. *Hint: use an outer join and return only those rows where the rID is null*

## Exercise 4

List the names of the people who reviewed "Snow White". Use the movie title and not the mID in your WHERE clause. *Hint: This requires 3 tables.*

## Exercise 5

Find the number of ratings made by each reviewer. Your query result should display the name of the reviewer and the number of reviews for that reviewer.

And nere arethe tables and data (in pictures)... Movie mID title 101 Gone with the Wind 102 Star Wars 103 The Sound of Music 104 E.T 105 Titanic 106 Snow White 107 Avatar 108 Raiders of the Lost YearDirector 1939 Victor Fleming 1977 1965 Robert Wise 1982 Steven Spielber 1997 James Cameron 1937