SOL PlA as CODE TM_NONTH P_CODE TOTSALES 10010 10010 10010 10010 10010 10010 10011 10011 10011 10011 10012 10012 74.5 19.9 14.97 70.44 180.26 180.26 109.2 20.97 130.89 130.89 20.7 20.97 10 13-r2 10 23109-HD 10 54778-2T 10 PUC23DRT 10 10 222QTY 10 SM-18277 10 9 SM-18277 9.5 256.99 266.94 287.91 10012 10 23109-HB 10012 10012 10012 10 9 URE-Q 10 Some records omitted in output shown 9 2238OPD 9 23109-HB 9 51778-27 9 PUC23DRT 10018 10018 10018 10018 10018 10018 10019 10019 10019 38.95 9.95 9.90 70.44 129.32 129.32 39.95 39.95 39.95 2252.06 9 1546-002 s8 rous selected.

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter8: Data And Network Communication Technology
Section: Chapter Questions
Problem 41VE
icon
Related questions
Question

What is the SQL command to list the total sales by customer, month, and product, with
subtotals by customer and by month and a grand total for all product sales? Figure
P13.6 shows the abbreviated results of the query.
FIGURE P13.6 PROBLEM 6 ABBREVIATED RESULT

SOL PlA
as CODE TM_NONTH P_CODE
TOTSALES
10010
10010
10010
10010
10010
10010
10011
10011
10011
10011
10012
10012
74.5
19.9
14.97
70.44
180.26
180.26
109.2
20.97
130.89
130.89
20.7
20.97
10 13-r2
10 23109-HD
10 54778-2T
10 PUC23DRT
10
10 222QTY
10 SM-18277
10
9 SM-18277
9.5
256.99
266.94
287.91
10012
10 23109-HB
10012
10012
10012
10 9 URE-Q
10
Some records omitted
in output shown
9 2238OPD
9 23109-HB
9 51778-27
9 PUC23DRT
10018
10018
10018
10018
10018
10018
10019
10019
10019
38.95
9.95
9.90
70.44
129.32
129.32
39.95
39.95
39.95
2252.06
9 1546-002
s8 rous selected.
Transcribed Image Text:SOL PlA as CODE TM_NONTH P_CODE TOTSALES 10010 10010 10010 10010 10010 10010 10011 10011 10011 10011 10012 10012 74.5 19.9 14.97 70.44 180.26 180.26 109.2 20.97 130.89 130.89 20.7 20.97 10 13-r2 10 23109-HD 10 54778-2T 10 PUC23DRT 10 10 222QTY 10 SM-18277 10 9 SM-18277 9.5 256.99 266.94 287.91 10012 10 23109-HB 10012 10012 10012 10 9 URE-Q 10 Some records omitted in output shown 9 2238OPD 9 23109-HB 9 51778-27 9 PUC23DRT 10018 10018 10018 10018 10018 10018 10019 10019 10019 38.95 9.95 9.90 70.44 129.32 129.32 39.95 39.95 39.95 2252.06 9 1546-002 s8 rous selected.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning