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.

-

create table Theatres (

Name varchar(255) primary key,

City varchar(255),

State varchar(255),

Zip int,

Phone varchar(255)

);

create table Movies (

Title varchar(255) primary key,

Rating int,

Length int,

ReleaseDate DATE ,

CHECK (Rating BETWEEN 0 AND 10),

CHECK (Length > 0)

);

create table ShownAT(

TheatreName varchar(255),

MovieTitle varchar(255),

PRIMARY KEY (TheatreName, MovieTitle)

);