Note: please don't copy answer from previous question in Chegg

Oracle SQL queries, one for each numbered point below.

Print the total dollar and the average dollar value of service visits (parts plus labour costs) and the number of those visits for each of the car makes Mercedes and Jaguar which were sold from January 2017 to the end of 2018. Sort the output by highest number of visits to lowest. (5 marks)

SI schema contains customers that have bought one or more vehicles. They must be classified using the following criteria:

Customers that have bought only one car (Emerald class)

Customers that have bought two cars (Ruby class)

Customers that have bought more than two cars (Diamond class)

Using a single SELECT statement, display a list of customer names and what type of buyer they are for all those customers that have bought car make Jaguar. (5 marks)

Specialty Imports E-R Dlagram