Consider the following database schema and write queries to solve the problems: Movie (mID, title, year, director): each movie has an ID number (MID), a title, a release year, and a director Reviewer (rID, name): each reviewer has an ID number (rID) and a name. Rating (rID, MID, stars, ratingDate): each reviewer with an ID can give a movie with an mld a rating (1-5 stars) on a certain day (ratingDate). year RID name Please answer the following questions by writing SQL queries that computes the desired result. Your queries shouldn't depend on the content of the database. You can test your solutions by tracing them on the small sample database. Movie Reviewer Rating mID title director rID MID stars rating Date 101 Gone with the Wind 1939 Victor Fleming 201 Sarah Martinez 201 1012 2011-01-22 102 Star Wars 1977 George Lucas 202 Daniel Lewis 201 101 4 2011-01-27 103 The Sound of Music 1965 Robert Wise 203 Brittany Harris 202 106 4 104 E.T. 1982 Steven Spielberg 204 Mike Anderson 203 103 2 2011-01-20 105 Titanic 1997 James Cameron 205 Chris Jackson 203 108 4 2011-01-12 106 Snow White 1937 206 Elizabeth Thomas 203 108 2 2011-01-30 107 | Avatar 2009 James Cameron 207 James Cameron 204 101 3 2011-01-09 108 Raiders of the Lost Ark 1981 Steven Spielberg 208 Ashley White 205 103 3 2011-01-27 205 104 2 2011-01-22 205 1084