SQL updates

Question III. 4 (5 points) Insert a goodyear sponsor for all the race taken place in Italy and for Ferrari manufactured car.

SQL Queries

Question II-5 (3 points) Write an SQL query that returns the racers name that only drives Mercedes.

Question II-6 (4 points) Write an SQL query that returns the racers name that never participated in a rallycross race

Car Racer A_id Name 1 Sam 2 Suzan 3 Alice c_id C1 gender Birth_year M 1984 F 1982 F 1980 Manufacturer Hourse_power Mercedes 1000 Ferrari 5000 Mercedes 700 C3 Result result id c_id r_id A_id Time R1_1 C1 R11 400 R1_2 c2R12 600 R1_3 C3 R13 375 Race Rid Type Location R1 F1 UK Rally Cross Portugal R3F1 USA Sponsor R_id C_ID R1C1 R1 03 R2 S ponsor Motorola Pepsi Michelin C4 Schema: Racer: (A id, Name, gender, birth_year) Race (r id, type, location) Result (result id, c_id, A_id,R_id, time) c_id is a foreign key for car and A_id is foreign key for Racer and R_id is a foreign key for Race Sponsor (R id, C iD, Sponsor) Car (c id, make, horsepower) Car Racer A_id Name 1 Sam 2 Suzan 3 Alice c_id C1 gender Birth_year M 1984 F 1982 F 1980 Manufacturer Hourse_power Mercedes 1000 Ferrari 5000 Mercedes 700 C3 Result result id c_id r_id A_id Time R1_1 C1 R11 400 R1_2 c2R12 600 R1_3 C3 R13 375 Race Rid Type Location R1 F1 UK Rally Cross Portugal R3F1 USA Sponsor R_id C_ID R1C1 R1 03 R2 S ponsor Motorola Pepsi Michelin C4 Schema: Racer: (A id, Name, gender, birth_year) Race (r id, type, location) Result (result id, c_id, A_id,R_id, time) c_id is a foreign key for car and A_id is foreign key for Racer and R_id is a foreign key for Race Sponsor (R id, C iD, Sponsor) Car (c id, make, horsepower)