What is the SQL command to list the total sales by customer and by product, with subtotals by customer and a grand total for all product sales?
What is the SQL command to list the total sales by customer and by product, with subtotals by customer and a grand total for all product sales?
Chapter7: Database Administration
Section: Chapter Questions
Problem 11TD: Toys Galore currently has a credit limit of 7,500. Because Toys Galore has an excellent credit...
Related questions
Question
What is the SQL command to list the total sales by customer and by product, with subtotals by customer and a grand total for all product sales?
I tried
SELECT CUS_CODE,TM_MONTH,P_CODE,SUM(SALE_UNITS*SALE_PRICE) AS TOTSALES
FROM DWDAYSALESFACT JOIN DWTIME USING (TM_ID);
GROUP BY ROLLUP (CUS_CODE,TM_MONTH,P_CODE)
But got
ERROR 1140 (42000) at line 3: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'Ch13_SaleCo_DW.DWDAYSALESFACT.CUS_CODE'; this is incompatible with sql_mode=only_full_group_by
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning