Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions