Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions