Question: The underlined attribute(s) are the primary key Using the following tables create SQL queries: 1. Find the names of the theaters where movie1 is playing.

The underlined attribute(s) are the primary key

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.

The underlined attribute(s) are the primary key 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!