FIGURE $13\mathrm{.}20$ SALECO SNOWFLAKE SCHEMA

Problem $6$

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? Figure

P$13\mathrm{.}6$ shows the abbreviated results of the query. Problem $7$

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? Figure P$13\mathrm{.}7$ shows the abbreviated result of

the query.

Problem $8$

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? Figure P$13\mathrm{.}8$ shows the result of the

query. Problem $9$

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? Figure

P$13\mathrm{.}9$ shows the result of the query.