1. 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.
2. Show a list of total amount of money spent on the labour cost of servicing Toyota cars. Show the subtotals for each model
3. 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 total

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