SQL Queries

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)