Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. */

image text in transcribed

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

Database And Expert Systems Applications 24th International Conference Dexa 2013 Prague Czech Republic August 2013 Proceedings Part 1 Lncs 8055

Authors: Hendrik Decker ,Lenka Lhotska ,Sebastian Link ,Josef Basl ,A Min Tjoa

2013 Edition

3642402844, 978-3642402845

More Books

Students also viewed these Databases questions