Question: Using the state, Georgia, provide a solution for each request below using Microsoft SQL Server Management Studio. Can you please make a sequel code for
Using the state, Georgia, provide a solution for each request below using Microsoft SQL Server Management Studio.
Can you please make a sequel code for all 5 so i can put it in the system.
- Using data for all years, show total refunds, by store, with the highest level of refunds at the top.
-For 2015, show refunds by store with the largest level of total refunds at the top.
- For 2015, show refunds by month, with the month with the largest level of total refunds at the top.
- 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.
- For 2015, show total out-of-state sales by customer zip code, with the Zip Code with the largest amount shown at the top.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
