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
Get step-by-step solutions from verified subject matter experts
