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.
- 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.
- For 2015, show refunds by store with the largest level of total refunds at the top.Output should show Store Number, City, and Refunds.
- 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.
- 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.)
- 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
Get step-by-step solutions from verified subject matter experts
