Using this database schema: -car(licenseNo, vin, make, model, year) -customer(driver_id, name, street, city) -owner(lice

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Using this database schema: -car(licenseNo, vin, make, model, year) -customer(driver_id, name, street, city) -owner(lice

Post by answerhappygod »

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!***
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply