Question I.1 (3 Points) Write the SQL statement that returns the sponsor, the race id and the racer name they sponsored.

Question II-2 (4 Points) Write the SQL statement that returns the male racer s name, born before 1982 with their average race time.

Question II-3 (4 Points) Write the SQL statement that returns the racers name and associated race sponsor that drove a Mercedes car during at least one of their races.

Question II-4 (5 points). Write an SQL query that returns the manufacturer whose cars won the most races

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

Question II-7. (3 points) Write an SQL query that returns the manufacturer for cars with low horsepower, meaning all its manufactured cars are less than 800 horsepower.

Question II .8. (4 points) Write an SQL query that returns the car ids that finished the race in time smaller than all races average time.

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)