CMIS 420 Homework 3 Online Vehicle Sales OVS Database

Description

CMIS 420 Homework 3 Online Vehicle Sales OVS Database

1) Complete your OVS database through the Homework #2 requirements.
2) Add 25 customers so that you now have 50 total.
3) Add 25 vehicles so that you now have 50 total.
4) Add 200 sales so that you now have 250 total.
5) Via a single SELECT query display the total count of sales, and the lowest, average, and highest sale price.
6) Via a single SELECT query display all customer IDs, names, and zip codes of customers having purchased 5 or more vehicles.
7) Via a single SELECT query display the institution and loan type of the financing plan used for the most sales.
8) Via a single SELECT query display the vehicle make involved in the most sales and all customers having purchased a vehicle of that make.
9) Produce a detailed and formatted report showing the customer IDs, names, and zipcodes along with makes and models sold with summarized customer counts and make and model counts.