What is the SQL command to list the total sales by customer

Assignment Help Basic Computer Science

Reference no: EM132413506

Using the data provided in the SaleCo_DW database, solve the following problems.

1. 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?

2. What is the SQL command to list the total sales by customer, month and product, with subtotals by customer and by month and a grand total for all product sales?

3. What is the SQL command to list the total sales by region and customer, with subtotals by region and a grand total for all sales?

4. What is the SQL command to list the total sales by month and product category, with subtotals by month and a grand total for all sales?

5. What is the SQL command to list the number of product sales (number of rows) and total sales by month, with subtotals by month and a grand total for all sales?

6. What is the SQL command to list the number of product sales (number of rows) and total sales by month and product category with subtotals by month and product category and a grand total for all sales?

7. What is the SQL command to list the number of product sales (number of rows) and total sales by month, product category and product, with subtotals by month and product category and a grand total for all sales?

Using the answer to Problem 6 as your base, what command would you need to generate the same output but with subtotals in all columns? (Hint: Use the CUBE command).

Attachment:- Chapter 13-SaleCo-DW.rar

Reference no: EM132413506

Questions Cloud

Describe one dimensional classifications of motor skills : Describe one dimensional and two dimensional classifications of motor skills (Cf. Gentile, 2000). What arguments would you give in favor (or against).

Multiplier method of valuation : Which of the following is a step in using the multiplier method of valuation?

Demonstrate your ability to evaluate evolution of language : This competency will allow you to demonstrate your ability to evaluate the evolution of language within online and digital forums due to advances and changes.

What is the cost of equity : Springvale Corp. has EBIT of $25 million, before tax cost of debt of 9%, an unlevered cost of equity of 12%, a tax rate of 35% and debt of $75 million.

What is the SQL command to list the total sales by customer : 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?

What is defined as deviant in the physical world : This competency will allow you to demonstrate your understanding of deviance in the digital world and the changes to deviance that we see due to technological.

Determine x and y values that satisfy both equations : Write that system in the space below and solve that system to determine x and y values that satisfy both equations.

Pension liability should james report in its balance sheet : What pension liability should James report in its balance sheet for the year ended December 31, 2019?

Increase efficiency and improve break even position : What steps can a company in your chosen industry take to reduce costs and increase profits to increase efficiency and improve their break even position?

User Account

All Pages