Consider the Drivers-Cars-Reserves DB for a small rental car company:

Drivers(id, name, rating, age)

Cars(vin, maker, model, year, color)

Reserves(did, vin, date)

1. Give SQL statement each of the following operations:

1. Find the colors of cars reserved by Smith.
2. Find all ids of drivers who have a rating of at least 7 or reserved car with VIN:1HGCM82633A004352
3. Find the names of drivers who have not reserved a red car.
4. Find the names of drivers who have reserved at least two cars.
5. Find the driver ids of all drivers whose rating is better than some driver called Bob.
6. Find the driver ids of all drivers whose rating is better than every driver called Bob.
7. Find the driver ids of all drivers with the highest rating.
8. Find the names of drivers who have reserved all cars.