- Suppose We Have The Following Schema For A Large Car Rental Company Drivers Did Integer Name String Rating Intege 1 (46.42 KiB) Viewed 24 times
please solve all
Suppose we have the following schema for a large car rental company. Drivers (did: integer, name: string, rating: integer, age: real) Branch (bid:integer, branch name:string, phone:string) Cars (cid: integer, model: string, crear: integer, color:string, bid: integer) Police Ticket(ticket id, did:int, date:date amount:real) Rent (did: integer, cid: integer, day: date, payment type:string) Question3 60 marks) write the SQL statements. f) Find the names of drivers who have rented a 'red' and a brown car. g) Find the names of drivers who have not rented a 'blue' car. (Use nested queries) h) Find the names of drivers with the highest rating. i) Find the name and age of the oldest drivers. j) Find the names of drivers who are older than the oldest driver that has rating seven. k) What is the average age for each rating? 1) Find the age of the youngest driver who is eligible to vote (ie, is at least 18 years old) for each rating level with at least two such driver.