Question
Using AdventurWorks2008R2, write a query to retrieve the top 3 salespersons who have also sold products that were shipped to more than 10 states/provinces. Exclude
Using AdventurWorks2008R2, write a query to retrieve the top 3 salespersons who have also sold products that were shipped to more than 10 states/provinces. Exclude orders which don't have a salesperson specified for this query. Use TotalDue in SalesOrderHeader for calculating the total sales. The top 3 salespersons have the 3 highest total sales amounts. Use ShipToAddressID in SalesOrderHeader to determine what state/province a product was shipped to. If there is a tie, your solution must retrieve it. Include SalespersonID, Salesperson's lastname and firstname, total sales amount, and the number of unique states/provinces the salesperson's sold products were shipped to in the returned data. Sort the returned data by SalespersonID. */
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