Problem
Using the following information help me with the SQL commands. I'm a bit confused with how to join three tables to answer these questions as the book primarily goes over 2 tables being combined.
The database schema is as follows:
Cars (c_id:number, c_brand:string, color:string, c_condition:string)
Dealers (d_id:number, d_name:string, d_location:string)
Inventory (c_id:number, d_id:number, costpercar:number, instock:number)
A. What are the brand names of ALL teal cars?
B. Names of dealers who sell some purple car OR are in Dallas?
C. Names of dealers who sell some green car AND are in Atlanta?
D. Names of dealers that have more than 3,000 cars?
E. Summation of all the average cost of cars for each distributor?
F. How many new cars are being sold (in stock) by dealerships?