1. Show a list of the total amount of money spent on the labor cost of servicing Acura and Jaguar cars. Show the subtotals for each make and model

2. Write a query using analytic functions that will show the serial number, the price of each Acura car as well as the cumulative sale price totals.

Transcribed Image Text:

caryear carcolour cartrim PROSPECT custname VARCHAR2(20) NOT NULL carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) CHAR(4) VARCHAR2(12) VARCHAR2(16) optioncode CHAR2(4) OPTIONS custname + custcity optioncode CHAR(4) optiondesc VARCHAR2(30) optioncost NUMBER(7,2) H optionlistprice NUMBER(7,2) ||++ custstreet Specialty Imports E-R Diagram CUSTOMER VARCHAR2(20) VARCHAR2(20) custprovince CHAR(2) custpostal CHAR(7) custhphone CHAR(13) custbphone CHAR(13) NOT NULL VARCHAR2(20) NOT NULL NOT NULL DEFAULT 'ON' NOT NULL NOT NULL NOT NULL SERVINV servinvno CHAR(5) servdate DATE NOT NULL custname VARCHAR2(20) NOT NULL carserial CHAR(8) NOT NULL partscost NUMBER(7,2) laborcost NUMBER(7,2) taxrate NUMBER(4,2) DEFAULT 13.0 SERVWORK servinvno CHAR(5) workdesc VARCHAR2(80) ||++ Ho +H BASEOPTION optioncode CHAR(4) carserial CHAR(8) carserial CHAR(8) custname VARCHAR2(20) carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) NOT NULL caryear CHAR(4) NOT NULL extcolour VARCHAR2(12) NOT NULL H VARCHAR2(16) NOT NULL enginetype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL purchinvno CHAR(6) purchcost NUMBER(9.2) freightcost NUMBER(9.2) carlistprice NUMBER(9.2) cartrim PURCHINV purchinvno CHAR(6) purchfrom VARCHAR2(15) purchdate DATE CAR Text TRADEINV saleinvno CHAR(6) carserial CHAR(8) tradeallow NUMBER(9,2) INVOPTION saleinvno CHAR(6) O optioncode CHAR(4) optionprice NUMBER(7,2) -osaleinvno saledate salesman custname SALEINV CHAR(6) DATE NOT NULL VARCHAR2(20) NOT NULL VARCHAR2(20) NOT NULL NOT NULL carserial CHAR(8) CHAR(1) insfire inscollision CHAR(1) insliability CHAR(1) insproperty CHAR(1) taxrate licfee NUMBER(4,2) DEFAULT 13.0 NUMBER(6,2) discount NUMBER(8,2) commission NUMBER(8,2) carsaleprice NUMBER(9,2) title empname startdate EMPLOYEE manager VARCHAR2(20) но commissionrate NUMBER(3,1) VARCHAR2(26) VARCHAR2(20) DATE NOT NULL caryear carcolour cartrim PROSPECT custname VARCHAR2(20) NOT NULL carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) CHAR(4) VARCHAR2(12) VARCHAR2(16) optioncode CHAR2(4) OPTIONS custname + custcity optioncode CHAR(4) optiondesc VARCHAR2(30) optioncost NUMBER(7,2) H optionlistprice NUMBER(7,2) ||++ custstreet Specialty Imports E-R Diagram CUSTOMER VARCHAR2(20) VARCHAR2(20) custprovince CHAR(2) custpostal CHAR(7) custhphone CHAR(13) custbphone CHAR(13) NOT NULL VARCHAR2(20) NOT NULL NOT NULL DEFAULT 'ON' NOT NULL NOT NULL NOT NULL SERVINV servinvno CHAR(5) servdate DATE NOT NULL custname VARCHAR2(20) NOT NULL carserial CHAR(8) NOT NULL partscost NUMBER(7,2) laborcost NUMBER(7,2) taxrate NUMBER(4,2) DEFAULT 13.0 SERVWORK servinvno CHAR(5) workdesc VARCHAR2(80) ||++ Ho +H BASEOPTION optioncode CHAR(4) carserial CHAR(8) carserial CHAR(8) custname VARCHAR2(20) carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) NOT NULL caryear CHAR(4) NOT NULL extcolour VARCHAR2(12) NOT NULL H VARCHAR2(16) NOT NULL enginetype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL purchinvno CHAR(6) purchcost NUMBER(9.2) freightcost NUMBER(9.2) carlistprice NUMBER(9.2) cartrim PURCHINV purchinvno CHAR(6) purchfrom VARCHAR2(15) purchdate DATE CAR Text TRADEINV saleinvno CHAR(6) carserial CHAR(8) tradeallow NUMBER(9,2) INVOPTION saleinvno CHAR(6) O optioncode CHAR(4) optionprice NUMBER(7,2) -osaleinvno saledate salesman custname SALEINV CHAR(6) DATE NOT NULL VARCHAR2(20) NOT NULL VARCHAR2(20) NOT NULL NOT NULL carserial CHAR(8) CHAR(1) insfire inscollision CHAR(1) insliability CHAR(1) insproperty CHAR(1) taxrate licfee NUMBER(4,2) DEFAULT 13.0 NUMBER(6,2) discount NUMBER(8,2) commission NUMBER(8,2) carsaleprice NUMBER(9,2) title empname startdate EMPLOYEE manager VARCHAR2(20) но commissionrate NUMBER(3,1) VARCHAR2(26) VARCHAR2(20) DATE NOT NULL

Answer rating: 100% (QA)

Answer1 select Carcarmake Carcarmodel sumservinvlaborcost TotalLabo... View the full answer