Management at AdventureWorks wants to determine the day of the week which have the most sales in
Fantastic news! We've Found the answer you've been seeking!
Question:
Management at AdventureWorks wants to determine the day of the week which have the most sales in 2012. You will use the Sales.SalesOrderHeader table. You will need the following functions - DATENAME, SUM, COUNT. List the Day of the Week, Total Revenue (based on the SubTotal), the number of orders and the Revenue per Order. Sort the results by the Revenue per Order with the largest first.
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date: