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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!