USE AdventureWorksLT2012;

--1a. Write a SQL statement that pulls all of the records from the AdventureWorksLT SalesOrderHeader table.

--1b. Write a SQL statement that pulls all of the records from the AdventureWorksLT SalesOrderDetail table

--1c. Study the tables in the AdventureWorksLT database and pretend you will type in data for the scenario below (i.e. you will *NOT* use INSERT - pretend you will hand type in the data).

Explain how you would add records to the AdventureWorksLT database for the following scenario: An existing customer places an order for 3 distinct existing products, (i.e. not a quantity of 3 of one single product).

Use the following format for your explanation:

STEP 1: Open Table X and input N records.

STEP 2: Open Table Y and input N records.

etc.

Make sure to comment out your explanation.

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.