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. Provide a screenshot for each solution, with the screenshot showing your SQL code, the output data, and your name. (Note: In some cases, you will not be able to display all data, but you can display the first few items in the output.)

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.

Answer rating: 100% (QA)

1 Using data for all years show total refunds by store with the highest level of refunds at the ... View the full answer