Use Adventureworkslt2012 1a Write Sql Statement Pulls Records Adventureworkslt Salesorderh Q43826141
USE AdventureWorksLT2012;
–1a. Write a SQL statement that pulls all of the records fromthe AdventureWorksLT SalesOrderHeader table.
–1b. Write a SQL statement that pulls all of the records fromthe AdventureWorksLT SalesOrderDetail table
–1c. Study the tables in the AdventureWorksLT database andpretend 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 AdventureWorksLTdatabase for the following scenario: Anexisting customer places an order for 3 distinct existing products,(i.e. not a quantity of 3 of one single product).
Use the following formatfor 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 outyour explanation.
2. As a member of the AdventureWorksteam, you wonder …
— AdventureWorksLT has several hundred products.
— Is AdventureWorks getting orders for all 295?
— Or is AdventureWorksLT getting orders, again and again, for just2-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.
Expert Answer
Answer to USE AdventureWorksLT2012; –1a. Write a SQL statement that pulls all of the records from the AdventureWorksLT SalesOrder…
OR