Consider the MOVIES relational database schema description: A movie can have 0 or more actors A movie can have 1 or more categories A movie has 1 and only one language Rating is one of these values: 'G','PG','PG-13','R', 'NC-17' People can comment about the movies in a webpage, and the comments are stored in the comments table. The reviewer_name is introduced by the person on each comment, so we don't have a table with "reviewers". A reviewer can create any number of comments about a movie The comments will have a score about the movie with values from 0 to 100. Note, the last update fields are going to be stored as a "timestamp". IMPORTANT: 2 entries in the same relation can have the same lastupdate, so, for example, 2 movies can have the same lastupdate value. The relations are: ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update) CATEGORY (category_id, name, last_update) FILM (film_id, title, description, release_year, language_id, length, rating, last_update) FILM_ACTOR(actor_id, film_id, last_update) FILM_CATEGORY (film_id, category_id, last_update) COMMENTS (review_id, film_id, reviewer_name, comment, score, last_update) 2. (5 points each) Write the following queries in MYSQL, using the schema provided above. To write these queries it is strongly recommended to use "MySQL" or SQLFiddle (in the MySQL mode). The query (set of queries) tested on those can be copied and pasted as solution in fact that is what is expected). We will test your queries in a real environment to check if they work or not. 1. a (2 points) Find all the Comments created by "Andrea 12" with score lower than 50 b (3 points) Find the Film title and the length from all the movies in the category "Horror" and length bigger than 180 minutes. 2. (5 points) Find the last name of all the actors in the movies with at least a comment with a score greater than 80. 3. (5 points) Find the Content and the Reviewer Name for each comment, about "ACE GOLDFINGER" only if the same reviewer has not commented about "ACADEMY DINOSAUR". 4. (5 points) Retrieve the title of all the Movies in Italian and without actors with first name "JOHN", ordered alphabetically. 5. (5 points) Find all the movie titles where and actor called "JOHN" OR an actor called "BEN" acted, where there was another actor called "MARY" acting too. (That means movies with JOHN and MARY, movies with BEN and MARY and movies with JOHN, BEN and MARY) 6. (5 points) Find the reviewers that have reviewed movies in all the categories. 7. (5 points) Movies have a length in minutes. Show a list with all the lengths ordered from longer to shorter, and the number of movies for each of the lengths. 8. (5 points) Show the 5 categories with the longer average length (show the name of the category and the average length of the movies for each category) order by average length from longer to shorter and in case of "tie" ordered by category name in alphabetical order