NA SQL Movie-Rating Query Exercises Bomage Exercise dun Mar 31, 2021 13:31 EDT Youve started a new movie-rating website, and you've been collecting data on reviewers ratings of various movies. There's not much data yet, but you can still try out some interesting queries. Here's the scheme Movie ( mid, title, year, director) English: There is a movie with ID number mo, ai, a release year, and a director Reviewer (Dame) English: The reviewer with ID number no has a certain name Rating nomi, stars, ratingDate English: The reviewer ro gave the movie mio a number of stars rating (1-5) on a certain rating Date Your queries will run over a small data set conforming to the schema View.the database. You can also download the scheme and data) Instructions: Each problem asks you to write a query in SOL To run your query against our back-end sample database using SQLite, click the "Submit button. You will see a display of your query result and the expected result. If the results match your query will be marked correct. You may run as many queries as you like for each question Important Notes Your queries are executed using SOLI, so you must conform the SOL constructs supported by Solite . Unless a specific rebutt ordering is asked for, you can return the result rows in any order You are to translate the English into a sol query but compute the desired result over all possib databases. All we actually check is that your query gets the right answer on the small amole database @ https://courses.edc.org/asser vi Stanford Online-SOEYDE SOL.001-272020-typ Movie ID title year director 101 Gone with the Wind 1030 Victor Fleming 102 Star Wars 1977 Genel 103 The Sound of Man 1965 Robert Wie 104 ET 1962 Steven Spielberg 105 mm 1997 Tames Cameron 106 SW White 1937cm YOT Avatar 2000 m Los Raiders of the Lost 1981 Steven Spie Review 301 Sarah Mati Dil Law 301 Brittany Hams 304 Mike Andenen 205 Crack 206 Thoma 07 Fames Cameron 20 Al White VID Date 2011012 2011-01 30110 2011-01-30 2021 103 1032 2011 01.30 2010 2011-01-13 Foto 101 0.000 205 101 30010 2011 0123 20 20010 SOTTOS 300106 2011 010 2017 2011 01:20 3051 2011-01-02 O type here to NA SQL Movie-Rating Query Exercises Bomage Exercise dun Mar 31, 2021 13:31 EDT Youve started a new movie-rating website, and you've been collecting data on reviewers ratings of various movies. There's not much data yet, but you can still try out some interesting queries. Here's the scheme Movie ( mid, title, year, director) English: There is a movie with ID number mo, ai, a release year, and a director Reviewer (Dame) English: The reviewer with ID number no has a certain name Rating nomi, stars, ratingDate English: The reviewer ro gave the movie mio a number of stars rating (1-5) on a certain rating Date Your queries will run over a small data set conforming to the schema View.the database. You can also download the scheme and data) Instructions: Each problem asks you to write a query in SOL To run your query against our back-end sample database using SQLite, click the "Submit button. You will see a display of your query result and the expected result. If the results match your query will be marked correct. You may run as many queries as you like for each question Important Notes Your queries are executed using SOLI, so you must conform the SOL constructs supported by Solite . Unless a specific rebutt ordering is asked for, you can return the result rows in any order You are to translate the English into a sol query but compute the desired result over all possib databases. All we actually check is that your query gets the right answer on the small amole database @ https://courses.edc.org/asser vi Stanford Online-SOEYDE SOL.001-272020-typ Movie ID title year director 101 Gone with the Wind 1030 Victor Fleming 102 Star Wars 1977 Genel 103 The Sound of Man 1965 Robert Wie 104 ET 1962 Steven Spielberg 105 mm 1997 Tames Cameron 106 SW White 1937cm YOT Avatar 2000 m Los Raiders of the Lost 1981 Steven Spie Review 301 Sarah Mati Dil Law 301 Brittany Hams 304 Mike Andenen 205 Crack 206 Thoma 07 Fames Cameron 20 Al White VID Date 2011012 2011-01 30110 2011-01-30 2021 103 1032 2011 01.30 2010 2011-01-13 Foto 101 0.000 205 101 30010 2011 0123 20 20010 SOTTOS 300106 2011 010 2017 2011 01:20 3051 2011-01-02 O type here to