1. Write an SQL query that returns the manufacturer for cars with low horsepower, meaning all its manufactured cars are less than 800 horsepower.

2. Write an SQL query that returns the cars that finished the race in time smaller than all races average time.

3. Write an SQL statement that increment the birth year by 2 for all the female racer

4. 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

5. Write an SQL statement that deletes the all race results whose participant are over 80 years old by the end of 2019.

6. Insert a goodyear sponsor for all the race taken place in Italy and for Ferrari manufactured car.

Racer A id Name 1 Sam 2 Suzan 3 Alice gender Birth_year M 1984 F 1982 F 1980 Car c id C1 C2 Manufacturer Hourse_power Mercedes 1000 Ferrari 5000 Mercedes 700 700 C3 Result result id c idrid A id Time R1_1 C1R1 1 400 R1_2 c2 R12 600 R1_ 3c3R13 375 Race R_id Type Location R1 F1 R2 RallyCross Portugal R3 F1 USA UK Sponsor R_id C_ID R1 c1 R1 C3 R2 C4 Sponsor Motorola Pepsi Michelin 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)