Using this database schema:
-car(licenseNo, vin, make, model, year)
-customer(driver_id, name, street, city)
-owner(license#, driver_id)
-claim(driver_id, licenseNo, date, description, amount)
Please write the following queries in SQL:
1) Retrieve each car license number and the name of its owner
2) Retrieve the name of each customer who owns either a Ford or a Toyota car that is made in the year 2022.
3) Find each customer’s name along with the number of his/her claims
4) Find the claim(s) with the largest amount
Thank you so much!!
***NOTE: Please do not copy and paste an answer already answered on answers (they are wrong). If you do not know how to answer, please pass the question. Thank you!***
Using this database schema: -car(licenseNo, vin, make, model, year) -customer(driver_id, name, street, city) -owner(lice
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am