Question: Using ch10_abc_markets database, write the SQL code to select the invoice year from inv_date with the column name invoice Year, the invoice month from inv_date

Using ch10_abc_markets database, write the SQL code to select the invoice year from inv_date with the column name invoice Year, the invoice month from inv_date with the column name invoice Month, the invoice day from inv_date with the column name invoice Day, and the sum of the invoice total with the column name invoice Total from the invoice table. Group the results by year, month, and day using the ROLLUP sub clause. What does the roll up sub clause provide in terms of grouping and how does it differ from the CUBE sub clause
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
