Question: 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

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) )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

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...

these pictures are the figures that are mentioned in the passage Specialty Imports Specialty Imports is an automobile dealership located on the "auto strip" in North-West Brampton (where several...

Assignment 1 This assignment will test your knowledge and skills acquired during the first three weeks of this course including Database Designing and Implementation course review. Assignment...

For this assignment you must use SI schema THIS IS ONE QUESTION WITH 5 PARTS. Print the total amount, the average dollar value of service visits (parts and labour costs) and the number of those...

For this assignment you must use SI schema. You are to create five queries as follows. Print the total dollar value, the average dollar value of service visits (parts and labour costs) and the number...

Specialty Imports E-R Diagram 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) NOT NULL...

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...

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

The Golf Digest 50 lists the 50 professional golfers with the highest total annual income. Total income is the sum of both on-course and off-course earnings. Tiger Woods ranked first with a total...

a. Define the term "conditions." b. Does the insurer have to pay an otherwise covered loss if the insured fails to comply with the policy conditions? Explain your answer.

To finance a new project, a company borrows R 4 million from a bank at 8 % per year. The stipulation on the loan is that the loan amount together with the interest will be repaid after 1 year. If the...

5 9 6 .

What are Decision Trees?

What is meant by the Term Glass Ceiling?

What Interface is used to develop Data Mining Structures in SQL Server Analytical Databases?