Problems and Exercises 19 through 26 deal with the Sales Analysis Module data mart available on Teradata University Network (www.teradatauniversitynetwork.com). To use Teradata University Network, you will need to obtain the current TUN password from your instructor. Go to the Assignments section of Teradata University Network or to this textbook’s Website to find the document “MDBM 10e SAM Assignment Instructions” in order to prepare to do the following Problems and Exercises. requested, use course password MDBM10e to set up your SQL Assistant account.
GROUP BY by itself creates subtotals by category, and the ROLLUP extension to GROUP BY creates even more categories for subtotals. Using all the orders, do a rollup to get total order amounts by product, sales region, and month and all combinations, including a grand total. Display the results sorted by product, region, and month. Put your query and the first portion of the answer set, including all of product 1 and a few rows for product 2, into a file for your instructor. Also, do a regular GROUP BY and put this query and the similar results from it into the file and then place an explanation in the file of how GROUP BY and GROUP BY with ROLLUP are different.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.