1. Using ch10_abc_markets database, write the SQL code to select the invoice year from inv_date with the column name invoiceYear, the invoice month from inv_date with the column name invoiceMonth, the invoice day from inv_date with the column name invoiceDay, and the sum of the invoice total with the column name invoiceTotal from the invoice table.  Group the results by year, month, and day using the ROLLUP subclause. QUESTION:  What does the rollup subclause provide in terms of grouping and how does it differ from the CUBE subclause? 2. Using ch10_abc_markets database and invoice table, write the SQL code to select the invoice number, line number and the sum of the line price as sumLP.  Group the results using grouping sets of invoice number and line number to show the sumLP by invoice number order. QUESTION:  What is the purpose of the GROUPING SETS subclause and what is its primary use? 3. What is data analytics?  Briefly explain explanatory and predictive analytics.

Looking for solution of this Assignment?


We deliver quality original papers

Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay