For this assignment, you must use the Sl schema. You are to create five queries as follows. 1. Print the total dollar value, the average dollar value of service visits (parts and labor costs) and the number of those visits for Jaguar and Mercedes car makes that were sold between January 2018 and November 2018 inclusive. 2. Write a query using analytic functions that will show the serial number, the model, and the sale price of each model of Land Rover as well as the cumulative sale price totals. The E-R diagram Specialty Imports E-R Diagram CUSTOMER custame VARCHAR2/20 custstreet VARCHAR2(20) NOT NULL custoly VARCHAR2(20) NOT NULL custprovince CHAR(2) NOT NULL DEFAULT ON custpostal CHAR(7) NOT NULL custhphone CHAR(13) NOT NULL custphone CHAR(13) NOT NULL CAR carserial CHAR(E) custame VARCHAR2/20) carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) NOT NULL caryear CHAR(4) NOT NULL excolour VARCHAR2(12) NOT NULL cartrim VARCHAR2(16) NOT NULL enginetype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL purchinno CHAR/6) purchcost NUMBER(92) freightcost NUMBER192) caristprice NUMBER(9.2) SALEINV Salve CHARG saledate DATE NOT NULL salesman VARCHAR2/20) NOT NULL custame VARCHAR2/20 NOT NULL carserial CHARIS NOT NULL insfire CHAR(1) inscollision CHAR(1) insliability CHARI) Insproperty CHAR() taxrate NUMBER(42) DEFAULT 130 licfee NUMBER(62) discount NUMBER(8.2) commission NUMBER/3.2) carsalepice NUMBER(9.2) PROSPECT cusmame VARCHAR2/20NOT NULL carmake VARCHAR2(102 NOT NULL carmodel VARCHAR2(10) carya CHAR4) carcolour VARCHAR2012) cartrim VARCHAR2016) optioncode CHAR210 SERVINV servinnoCHAR5 Servdate DATE NOT NULL Custname VARCHAR2(20) NOT NULL carseria CHAR NOT NULL parts.cost NUMBER(72) laborcos NUMBER(7.2) tarate NUMBER(4.2) DEFAULT 13.0 Ted RVWORK servinno CHAR(5) Workidesc VARCHAR2/80 PURCHINV Durchino CHAR/6) purchtrom VARCHAR2(15) purchate DATE TRADEINV saleinno CHARIGI carserial CHARES tradellow NUMBER(92) EMPLOYEE empname VARCHAR2200 startdate DATE NOT NULL commissionate NUMBER(1) title VARCHAR2/25) manager VARCHAR2/20) OPTIONS BASEOPTION optioncode CHAR Carsenal CHAR optioncode CHARLA optiondesc VARCHAR2/30 optioncost NUMBER(72) optionistprice NUMBER(72) INVOPTION salino CHAR(6) optioncode CHAR14 optionprice NUMBER(72