Using Adventureworkslt Salesorderheader Salesorderdetail Table Need Use Adventureworkslt20 Q43839917
(Using AdventureWorksLT SalesOrderHeader or SalesOrderDetailtable 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, forjust 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 modelID only once — and sort in order from lowest to highest. Note: Youwill display only the model id field.
Expert Answer
Answer to (Using AdventureWorksLT SalesOrderHeader or SalesOrderDetail table if need) USE AdventureWorksLT2012 1. As a member of t…
OR