Answered step by step
Verified Expert Solution
Link Copied!

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.

  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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Corporate Annual Reports

Authors: William Pasewark

7th Edition

0073526932, 9780073526935

More Books

Students also viewed these Accounting questions