Question: SELECT CUS_CODE, P_CODE, SUM(SALE_UNITS*SALE_PRICE) AS TOTSALES FROM DWDAYSALESFACT NATURAL JOIN DWCUSTOMER GROUP BY (CUS_CODE, P_CODE) WITH ROLLUP ORDER BY CUS_CODE,P_CODE; with this code I get

SELECT CUS_CODE, P_CODE, SUM(SALE_UNITS*SALE_PRICE) AS TOTSALES

FROM DWDAYSALESFACT NATURAL JOIN DWCUSTOMER

GROUP BY (CUS_CODE, P_CODE) WITH ROLLUP

ORDER BY CUS_CODE,P_CODE;

with this code I get a error saying incorrect usage of cube/rollup and order by what's wrong with it?

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 Mathematics Questions!

Q:

SELECT , P _ CODE, P _ PRICESELECT , P _ CODE, P _ ? - Q O H * * P - PRICEQuestion 1 Name the type of transparency ( location , replication, failure, and concurrency ) that is indicated by each...

Q:

SELECT , P _ CODE, P _ PRICESELECT , P _ CODE, P _ ? - Q O H * * P - PRICE FROM PRODUCT WHERE , P _ Q O H * * P ? PRICE > ( SELECT AVG PRICE ) FROM PRODUCT ) What is the likely data sparsity of the P...

Q:

SELECT , P _ CODE, P _ PRICESELECT , P _ CODE, P _ ? - Q O H * * P - PRICE FROM PRODUCT WHERE , P _ Q O H * * P ? PRICE > ( SELECT AVG PRICE ) FROM PRODUCT ) What is the likely data sparsity of the P...

Q:

2. Display employee last name and managers last name for all employees. Use appropriate column headings in your result such as EMPLOYEE and MANAGER. (Managers EMP_NUM is available in EMP_MGR column...

Q:

Use the SaleCo ERD listed below and the provided SQL scripts to construct its relational database and answer the following queries. Write a query to count the number of invoices. Write a query to...

Q:

You need to first run the SQL script posted on Moodle to create the following tables and insert data into them. Table Name Primary Key P P_CODE V V_CODE CUSTOMER CUS_CODE EMP EMP_CODE INVOICE...

Q:

This is a sample of the query but it's not correct the mistake I get is Invalid use of group function. select CONCAT(C.CUS_FNAME ,' ) 'CUS_FNAME , ROUND SUMCP.P_PRICE ) ) 'Total Money Spent from...

Q:

QUESTIONS 5-18 In either ORACLESQLDevleoper or MYSQL For each query, show your SQL statement and the corresponding output from the DBMS in your Microsoft Word document that you submit. DDL: CREATE...

Q:

You need to first run this SQL script then use it to answer the following questions. /* ADVSQLDBINIT.SQL */ /* Advanced SQL */ /* Script file for MS SQL Server DBMS */ /* This script file creates the...

Q:

You need to first run this SQL script then use it to answer the following questions. /* ADVSQLDBINIT.SQL */ /* Advanced SQL */ /* Script file for MS SQL Server DBMS */ /* This script file creates the...

Q:

How would you know whether your firm was doing a good or bad job of managing employee diversity? What type of data would you need to answer this question?

Q:

Lew Pherson and Vera Collier are friends who are employed by different CPA firms. One day during lunch they are discussing the importance of internal control in determining the amount of audit...

Q:

What should your primary focus be as you summarize your key findings in the Communicate Your Results step of the data analysis process? A. Including as much data as possible B. Clarity and...

Q:

Oust the Turtle Company has the following balances on December 31, 2020: Cash on hand 4,500.00 Cash in bank A 33,000.00 Cash in bank X 50,000.00 Cash in bank C 822,999.72 Cash on hand includes $ 3....