Using ch10_abc_markets database, Management Assignment Homework Help
User Generated
Oenvajbexf
Business Finance
Description
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.
This question has not been answered.
Create a free account to get help with this and any other question!
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Dr Jekyll And Mr Hyde
by Robert Louis Stevenson
The Hobbit
by J. R. R. Tolkien
Daisy Miller
by Henry James
The Adventures of Huckleberry Finn
by Mark Twain
Mrs Dalloway
by Virginia Woolf
The Tipping Point
by Malcolm Gladwell
Tess of the DUrbervilles
by Thomas Hardy
Heart of Darkness
by Joseph Conrad
Milkweed
by Jerry Spinelli