using SI Schema

Instructions

List of Customers Interested in Different Make:

Using SET operations, display a list of customers that are interested in a car $($prospect table$)$ of any different make which they already own.

Total Labour and Parts Cost:

Using a single SELECT statement, generate a list of total labour and parts cost of servicing Land Rover and BMW cars. The query should show subtotals for each make and for each model. Your query should produce no grand total.

Highest and Lowest Car Sale Prices:

Using analytic functions, display the highest and the lowest car sale prices for each make in the SI database and rank them based on the highest price in descending order.

Customer Who Bought the Third Most Expensive Car:

Using analytic functions, return the name of the customer who bought the third most expensive car.

Car Price and Difference from Average in Burlington:

For each customer from Burlington, return the price of the car they bought and the difference between that price and the average price of the cars sold in that city.