(Using AdventureWorksLT SalesOrderHeader or SalesOrderDetail table if need)

USE AdventureWorksLT2012

1. As a member of the AdventureWorks team, you wonder ...

-- AdventureWorksLT has several hundred products.

-- Is AdventureWorks getting orders for all 295?

-- Or is AdventureWorksLT getting orders, again and again, for just 2-3 products?

-- Are there products that have never been ordered?

-- Research and explain.

-- Make sure to comment out your explanation.

-- Write a query statement that supports your explanation.

3. List all AdventureWorks products model IDs. List each model ID only once -- and sort in order from lowest to highest. Note: You will display only the model id field.