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:
- Find the mname of movies for which there is some producer.
- Find the pname of producers who produce every movie.
- Find the pname of producers who produce every Action movie.
- 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
Get step-by-step solutions from verified subject matter experts
