Using the following tables create SQL queries:

1. Find the name and the phone number of the theaters that show the maximum number of movies. Make sure your query works when there is a tie between several theaters.

2. Find the average ratings of all movies playing at each theater. Display the theater name and the computed rating. Order the results ascending by rating

-

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)

);