Select a state that contains at least 3 Dillards 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.
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