Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started