Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I did 1 a,b,c already. only want to help with#2,3 USE AdventureWorksLT2012; --1a. Write a SQL statement that pulls all of the records from the

I did 1 a,b,c already. only want to help with#2,3

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.

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Implementation

Authors: Edward Sciore

2nd Edition

3030338355, 978-3030338350

More Books

Students also viewed these Databases questions

Question

=+3. What is content curation and its role within social media?

Answered: 1 week ago