Using the following tables create SQL queries:

1. Find the names of the theaters where movie1 is playing.

2. Find the names and the phone numbers of theaters that do not show the movie movie2.

3. Find the minimum and maximum length of movies playing in each city.

-

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)

);