Write a query using analytic functions that will show the serial number, the model and the service parts cost of each model of Mercedes as well as the cumulative parts cost totals.

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