Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
SQL Queries for Car Sales and Service
Answered

Query 1: Sales and Service Summary by Car Make

1.Print the total amount, the average dollar value of service visits (parts and labour costs) and the number of those visits for Acura, Mercedes and Jaguar car makes that are sold between September 2015 and December 2018 inclusive
2.SI schema contains customers that have bought one or more vehicles. They can be classified using the following criteria:
a.Customers that have bought only one car (one-time buyer)
b.Customer that have bought two cars (two-time buyer)
c.Customers that have bought more than two cars (frequent buyer)
Using a SINGLE SELECT statement, display a list of customers with their names and what type of buyer they are for all those customers that have bought Mercedes car makes.
3.Using SET operations, display a list of customers that are interested in a car (prospect table) of the same make and model which they already own.
4.Show a list of total amount of money spend on the labour cost of servicing Toyota cars. Show the subtotals for each model
Write a query using analytic functions that will show the serial number, the price of each JAGUAR car as well as the cumulative sale price totals.

support
close