equired to complete the following MySQL statement to perform this task: each of the product category, display (in this order) the category name (in English), the total numbe category, the total number of sales orders of the category, and the total sales amount in the catege g in each blank below; do not enter space or other unnecessary symbols; assume that all strings are non- otal sales should be equal to the sum of all the total sales in Question 8). CT C. Num_Products, AS 'Product Category'. ) AS Num_Orders, f.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Question 10
Save Answer
Adventure Works Cycle Data Warehouse: The Adventure Works Cycle Data Warehouse is available for your use in the course database server
(follow the steps in Tutorial 2 to access the data warehouse (named "aw") and review the course Handout 8, slides 13-18 for the description). You
are required to complete the following MYSQL statement to perform this task:
For each of the product category, display (in this order) the category name (in English), the total number of unique products belonging to
the category, the total number of sales orders of the category, and the total sales amount in the category. (enter only one alphanumeric
string in each blank below; do not enter space or other unnecessary symbols; assume that all strings are non-case sensitive. Hint: The sum of all
the total sales should be equal to the sum of all the total sales in Question 8).
SELECT c.
AS 'Product Category',
р.
) AS Num_Products,
(f.
) AS Num_Orders,
(f.
) AS
Total_Sales
FROM
C,
P.
S,
f
WHERE p.
=s.
AND s.
=c.
AND f.
=p.
c.
Transcribed Image Text:Question 10 Save Answer Adventure Works Cycle Data Warehouse: The Adventure Works Cycle Data Warehouse is available for your use in the course database server (follow the steps in Tutorial 2 to access the data warehouse (named "aw") and review the course Handout 8, slides 13-18 for the description). You are required to complete the following MYSQL statement to perform this task: For each of the product category, display (in this order) the category name (in English), the total number of unique products belonging to the category, the total number of sales orders of the category, and the total sales amount in the category. (enter only one alphanumeric string in each blank below; do not enter space or other unnecessary symbols; assume that all strings are non-case sensitive. Hint: The sum of all the total sales should be equal to the sum of all the total sales in Question 8). SELECT c. AS 'Product Category', р. ) AS Num_Products, (f. ) AS Num_Orders, (f. ) AS Total_Sales FROM C, P. S, f WHERE p. =s. AND s. =c. AND f. =p. c.
FactInternetSales
DimPromotion
Productkey
DimCustomer
8
PromotionKey
OrderDatekey
7 Customerkey
PromotionAlternatekey
DueDatekey
Geographykey
ShipDatekey
Customer Alternatekey
CustomerKey
Promotionkey
Currencykey
SalesTerritorykey
DimDate
9 SalesOrderNumber
9 Datekey
pod SalesOrderLineNumber
FulDateAternatekey
RevisionNumber
DimGeography
OrderQuantity
V
Geographykey
UnitPrice
SalesTerritorykey
ExtendedAmount
UnitPriceDiscountPct
DiscountAmount
ProductStandardCost
DimCurrency
7 Currencykey
TotalProductCost
SalesAmount
CurrencyAlternatekey
ТахАmt
DimSalesTerritory
7 SalesTerrikoryKey
Freight
CarrierTrackingNumber
CustomerPONumber
SalesTerrkoryAlternate...
OrderDate
DimProduct
DueDate
7 Productkey
ShipDate
ProductAlternatekey
ProductSubcategorykey
StartDate
FactInternetSalesRea
9 SalesOrderNumber
T| SalesOrderLineNumber
DimProductSubcategc
DimProductCategory
9
ProductSubcategoryKey
ProductCategorykKey
ProductSubcategoryAlt...
ProductCategoryAkern..
7 SalesReasonkey
ProductCategorykey
Transcribed Image Text:FactInternetSales DimPromotion Productkey DimCustomer 8 PromotionKey OrderDatekey 7 Customerkey PromotionAlternatekey DueDatekey Geographykey ShipDatekey Customer Alternatekey CustomerKey Promotionkey Currencykey SalesTerritorykey DimDate 9 SalesOrderNumber 9 Datekey pod SalesOrderLineNumber FulDateAternatekey RevisionNumber DimGeography OrderQuantity V Geographykey UnitPrice SalesTerritorykey ExtendedAmount UnitPriceDiscountPct DiscountAmount ProductStandardCost DimCurrency 7 Currencykey TotalProductCost SalesAmount CurrencyAlternatekey ТахАmt DimSalesTerritory 7 SalesTerrikoryKey Freight CarrierTrackingNumber CustomerPONumber SalesTerrkoryAlternate... OrderDate DimProduct DueDate 7 Productkey ShipDate ProductAlternatekey ProductSubcategorykey StartDate FactInternetSalesRea 9 SalesOrderNumber T| SalesOrderLineNumber DimProductSubcategc DimProductCategory 9 ProductSubcategoryKey ProductCategorykKey ProductSubcategoryAlt... ProductCategoryAkern.. 7 SalesReasonkey ProductCategorykey
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY