Problem
Using the following information please 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. Please explain the joins, also I've had an issue with not getting duplicate results, I've been able to answer these questions but not efficiently as I'll get so much duplicate data returned.
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?