+
CMIS 420 HOMEWORK 3 ONLINE VEHICLE SALES OVS DATABASE

CMIS 420 HOMEWORK 3 ONLINE VEHICLE SALES OVS DATABASE

Rating:
Rating
(0)
Author: Carol 96
Description:

http://theperfecthomework.com/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.


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial