Question: Select a state that contains at least 3 Dillard's stores and provide a solution for each request below using Microsoft SQL Server Management Studio. Using

Select a state that contains at least 3 Dillard's stores and provide a solution for each request below using Microsoft SQL Server Management Studio.

  1. Using data for all years, show total refunds, by store, with the highest level of refunds at the top. Output should show Store Number, City, and Total Refunds.
  2. For 2015, show refunds by store with the largest level of total refunds at the top.Output should show Store Number, City, and Refunds.
  3. For 2015, show refunds by month, with the month with the largest level of total refunds at the top. Output should show Month and Total Refunds.
  4. For 2015, show total sales to out-of-state customers for each store, with the largest level of out-of-state sales at the top. Output should show Store Number, City, and Total Out-of-State Sales.(Please note this is not Net Sales but instead is Total Sales.)
  5. For 2015, show total out-of-state sales by customer zip code, with the Zip Code with the largest amount shown at the top.Output should show Zip Code, State, and Total Purchases. I need to know what SQL codes would give me this information. Please help

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 Accounting Questions!