InstructionsUsing the data provided in the Ch13_SaleCo; database, solve the following problems.(Hint: In Problems 5–11, use the ROLLUP command.)Below is the Schema for the database:Problem 5What 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? Figure P13.5 shows the abbreviated results of the query. FIGURE 13.20 SALECO SNOWFLAKE SCHEMADWREGIONDWTIMEDWVENDORPK REG IDPK TM IDPK V CODEV_NAMEV_AREACODEV_STATEREG_NAMETM_YEARTM_MONTHTM_DAYTM_QTRDWCUSTOMERDWSALESFACTDWPRODUCTP CODEPK,FK2 TM_IDPK,FK1O PK,FK3 P CODEPKCUS_CODEPKCUs CODE%23CUS_LNAME +CUS FNAMECUS INITIALCUS_STATEFK1 REG_IDP_DESCRIPTP_CATEGORYV_CODESALE_UNITSSALE_PRICEFK1 CUS_CODEP CODETOTSALES1001013-Q2/P274.951001023109-HB19.901001054778-2T14.9710010PVC23DRT70.44Some records omittedin output shown1001854778-2T9.9810018PVC23DRT70.4410018NULL129.32100191546-QQ239.9510019NULL39.95NULLNULL2252.06

The rollup command is the extension of the group by clause. It allows to add extra rows which…

Answered: Using the data provided in the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Instructions

Using the data provided in the Ch13_SaleCo; database, solve the following problems.
(Hint: In Problems 5–11, use the ROLLUP command.)

Below is the Schema for the database:

Problem 5

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? Figure P13.5 shows the abbreviated results of the query.

FIGURE 13.20 SALECO SNOWFLAKE SCHEMA
DWREGION
DWTIME
DWVENDOR
PK REG ID
PK TM ID
PK V CODE
V_NAME
V_AREACODE
V_STATE
REG_NAME
TM_YEAR
TM_MONTH
TM_DAY
TM_QTR
DWCUSTOMER
DWSALESFACT
DWPRODUCT
P CODE
PK,FK2 TM_ID
PK,FK1
O PK,FK3 P CODE
PK
CUS_CODE
PK
CUs CODE
%23
CUS_LNAME +
CUS FNAME
CUS INITIAL
CUS_STATE
FK1 REG_ID
P_DESCRIPT
P_CATEGORY
V_CODE
SALE_UNITS
SALE_PRICE
FK1

CUS_CODE
P CODE
TOTSALES
10010
13-Q2/P2
74.95
10010
23109-HB
19.90
10010
54778-2T
14.97
10010
PVC23DRT
70.44
Some records omitted
in output shown
10018
54778-2T
9.98
10018
PVC23DRT
70.44
10018
NULL
129.32
10019
1546-QQ2
39.95
10019
NULL
39.95
NULL
NULL
2252.06

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions