Question: Write an SQL query that returns the racers name that only drives Mercedes. Car Racer Aid Name 1 Sam 2 Suzan Alice gender Birth year

Write an SQL query that returns the racers name that only drives Mercedes.

Write an SQL query that returns the racers name that only drives

Car Racer Aid Name 1 Sam 2 Suzan Alice gender Birth year 1984 1982 1980 C1 C2 Manufacturer Hourse power Mercedes 1000 Ferrari 5000 Mercedes 700 F Result result id c id rid A id Time R1_1 C1R1 1 400 R1_2 c2 R1 2 600 R1_3 C3 R1 3 375 Race R.id Type Location R1 F1 UK RallyCross Portugal R3F1 USA Sponsor Rid C_ID C1 C3 | R2 CA R1 Sponsor Motorola Pepsi Michelin R1 Schema: Racer: (A id, Name, gender, birth year) Race (r_id, type, location) Result (result id, c.id, A id.R.id, time) id is a foreign key for car and A id is foreign key for Racer and Rid is a foreign key for Race Sponsor (R.id, iD, Sponsor) Car (c_id, make, horsepower)

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!