Question III .1 (2 points) Write an SQL statement that increment the birth year by 2 for all the female racer

Question III-2 (3 points) Write an SQL statement that reduces the horsepower by 5% of all Ferrari car manufacturer and increases the horsepower by 10% for all the Mercedes car manufacturer

Question III-3 (3 points) Write an SQL statement that deletes the all race results whose participant are over 80 years old by the end of 2019.

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

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)