The underlined attribute(s) are the primary key

Using the following tables create SQL queries:

1. Find the average rating of all movies playing in each city. Display the city name and the computed rating. Order the results descending by rating.

2. Find the titles of the newest movies shown in each city. Display the city name and the newest movie title ordered by city name and movie title.

Table 1: Theatres Name City State Zip Phone Table 2: Movies Title Rating Rating Length ReleaseDate Release Date Table 3: ShownAt TheatreName Movie Title