Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started