--* BUSIT 103 Assignment #2 DUE DATE: Consult course calendar /***** You are to develop SQL statements for each task listed. You should type your SQL statements under each task. The fields' names are written as if a person is asking you for the report. You will need to look at the data and understand that list price is in the ListPrice field, for example. Add comments to describe your reasoning when you are in doubt about something. To find the tables that contain the fields that are requested, consider creating a Database Diagram that includes only the tables from the SalesLT schema and referring to it. *****/

/***** Do not remove the USE statement. *****/

USE AdventureWorksLT2012;

--2. 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.