Question: With the following relations: Producers( pid : integer, pname : string, address : string) Movies( mid : integer, mname : string, category : string) Theaters(

With the following relations:

Producers(pid: integer, pname: string, address: string)

Movies(mid: integer, mname: string, category: string)

Theaters(pid: integer, mid: integer, price: real)

The Theaters relation lists the ticket price of movies from different producers. Write the following queries in SQL:

  1. Find the mname of movies for which there is some producer.
  2. Find the pname of producers who produce every movie.
  3. Find the pname of producers who produce every Action movie.
  4. Find the mname of movies produced by Paramount and no other producers (e.g., some movies may be produced by multiple producers).

[IF POSSIBLE CAN YOU DO IT WITHOUT USING "INNER JOIN"]

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!