Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I under stand the s is an alias for DWDAYSALESFACT but why was the s chosen for SALES over d for DAY in DWDAYSALESFACT Step
I under stand the s is an alias for DWDAYSALESFACT but why was the s chosen for SALES over d for DAY in DWDAYSALESFACT
Step 3 of 5 A Consider the following query to display the TOTSALES by customer, month and product, with subtotals by customer and by month and a grand total for all the product sales. The SOL command is written using SQL-Server 2014 syntax. Query: SELECT s.CUS CODE, t.TM MONTH, s.P CODE, SUM(S.SALE UNITS s.SALE PRICE) AS TOTSALES FROM DWDAYSALESFACT as s INNER JOIN DWTIME as t on s.TM.ID=t.TM.ID GROUP BY ROLLUP (s.CUS_CODE, t.TM MONTH, s.P CODE) ORDER BY s.CUS CODE, t.TM MONTH, S.P CODE Step 3 of 5 A Consider the following query to display the TOTSALES by customer, month and product, with subtotals by customer and by month and a grand total for all the product sales. The SOL command is written using SQL-Server 2014 syntax. Query: SELECT s.CUS CODE, t.TM MONTH, s.P CODE, SUM(S.SALE UNITS s.SALE PRICE) AS TOTSALES FROM DWDAYSALESFACT as s INNER JOIN DWTIME as t on s.TM.ID=t.TM.ID GROUP BY ROLLUP (s.CUS_CODE, t.TM MONTH, s.P CODE) ORDER BY s.CUS CODE, t.TM MONTH, S.P CODE 
Step by Step Solution
There are 3 Steps involved in it
Step: 1

Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2

Step: 3

Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started