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:
   1. Customers that have bought only one car (one-time buyer)
   2. Customer that have bought two cars (two-time buyer)
   3. 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.

Specialty Imports E-R Diagram SALEINV custame CUSTOMER VARCHAR2(20 VARCHAR2(20) NOT NULL od satelnyno CHARG) custstreet saledate DATE NOT NULL #custcity CAR VARCHAR2(20) NOT NULL carserial CHAR(8) salesman VARCHAR2(20) NOT NULL custprovince CHAR(2) NOT NULL DEFAULT ON custname VARCHAR2(20) custhame VARCHAR2(20) NOT NULL custpostal CHAR(7) NOT NULL carmake VARCHAR2(10) NOT NULL carserial CHARIS) NOT NULL custhphone CHAR(13) NOT NULL carmodel insfire VARCHAR2(10) NOT NULL CHAR(1) custophone CHAR(13) NOT NULL caryear CHAR(4) inscollision CHAR(1) NOT NULL extcolour insliability VARCHAR2(12) NOT NULL CHAR(1) cartrim SERVINV VARCHAR2(16) NOT NULL insproperty CHAR(1) PROSPECT taxrate NUMBER(42) DEFAULT 13.0 Custhame VARCHAR2(20) NOT NULL servinvnoCHAR(5) enginetype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL licfee NUMBER(6,2) camake VARCHAR2(10) NOT NULL servdate DATE NOT NULL discount NUMBER(82) purchinvno CHAR(6) camodel VARCHAR2/10 custame VARCHAR2(20) NOT NULL commission NUMBER(82) purchcost NUMBER(92) caryear CHARIA carserial CHAR(8) NOT NULL carsaleprice NUMBER(9.2) freightcost NUMBER(92) carcolour VARCHAR2(12) partscost NUMBER(72) carlistprice NUMBER(9.2) laborcost NUMBER(72) cartrim VARCHAR2(16) optioncode CHAR24 tasate NUMBER(42) DEFAULT 13.0 Text TRADEINV PURCHING EMPLOYEE SERVWORK saleinyno CHAR(6) empname VARCHAR2:20) purchinyno CHAR(6) carserial CHAR(9) servinvno_CHAR(5) VARCHAR2(15) startdate purchfrom DATE NOT NULL tradeallow NUMBER/9.2) wordesc VARCHAR2(80) commissionate NUMBER(3.1) purchdate DATE VARCHAR2(26) OPTIONS BASEOPTION manager VALLEHAR2/20) INVOPTION option code CHAR 4 optioncode CHAR(4) CHAR(6) optiondesc saleinvno VARCHAR2:30 carserial CHAR(B) 04 optioncode CHAR(4) optioncost NUMBERT 2 optionprice NUMBER (72) option istorice NUMBER 7.2