Question

SQL query exercises:

Consider the following database schema:

               Product(maker, model, type)

               PC(model, speed, ram, hd, rd, price)

               Laptop(model, speed, ram, hd, screen, price)

               Printer(model, color, type, price)

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 id’s 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 id’s of all drivers whose rating is better than some driver called Bob.
6. Find the driver id’s of all drivers whose rating is better than every driver called Bob.
7. Find the driver id’s of all drivers with the highest rating.
8. Find the names of drivers who have reserved all cars.

Answer 1

If you have any questions comment down. Please don't post so many questions at once. We have been aske to solve only 4 sub questions at a time. If you are satisfied with answer please? upvote thanks