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 P13.8 shows the result of the query. Tм MONTH P_CATEGORY...


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 P13.8 shows the result of the query.


Tм MONTH<br>P_CATEGORY<br>TOTSALES<br>CAT1<br>174.83<br>CAT2<br>446.81<br>CAT3<br>537.54<br>9<br>CAT4<br>80.67<br>9<br>NULL<br>1239,85<br>10<br>CAT1<br>124.89<br>10<br>CAT2<br>366.91<br>10<br>CAT3<br>459.64<br>10<br>CAT4<br>60.77<br>10<br>NULL<br>1012.21<br>NULL<br>NULL<br>2252.06<br>

Extracted text: Tм MONTH P_CATEGORY TOTSALES CAT1 174.83 CAT2 446.81 CAT3 537.54 9 CAT4 80.67 9 NULL 1239,85 10 CAT1 124.89 10 CAT2 366.91 10 CAT3 459.64 10 CAT4 60.77 10 NULL 1012.21 NULL NULL 2252.06

Jun 02, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?