University of Mary Washington SaleCo DW2b Database Questions Paper

Question Description

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?

you need Access app in order to complete the question.

^{"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."}