1. Write the SQL statement that returns the sponsor, the race and the racer name they sponsored.

2. Write the SQL statement that returns the male racer s name, born before 1982 with their average race time.

3. Write the SQL statement that returns the racer's name and associated race sponsor that drove a 'Mercedes' car during at least one of their races.
4. Create SQL query that returns the manufacturer whose cars won the most races
5. what is SQL query that returns the racer's name that only drives Mercedes.
6. what is the SQL query that returns the racer's name that never participated in a 'rallycross' race
7. what is the SQL query that returns the manufacturer for cars with low horsepower, meaning all its manufactured cars are less than 800 horsepower.
8. what is the SQL query that returns the cars that finished the race in time smaller than all races average time.

LO Racer A_id Name 1 Sam Suzan 3 Alice c id C1 gender Birth_year M 1984 1982 F 1980 Manufacturer Hourse_power Mercedes 1000 Ferrari 5000 Mercedes 700 +Result result id c_idr id A id R1_1 C1 R11 R1 2 C2 R1 2 R1_3 C3 R1 3 Time 400 600 375 Race Sponsor RidType Location name R_id C_ID R1 F1 UK Premier R1C1 R2 RallyCross Portugal Bahrain R1 03 R3 F1 USA Grand Primel | R2 | 04 Sponsor Motorola | Pepsi Michelin | difficultyLevel RaceLap name Grand Prix Bahrain GulfAir | 23 Location streetName streetNumber length Australia George 345.2 Portugal | Williams 54 594.2 Mexico Juarez 870 687.54