use Adventure Works Database Run each query and save the notebook with the results before submitting
Question:
use Adventure Works Database
Run each query and save the notebook with the results before submitting it.
All the questions below are related to AdventureWorks database. make sure your notebook is connected to it. Each Question is 10 points.
- Questions 1-5 will require you to use only Production.Product table
- Question 6 will require you to use Sales.SalesOrderDetail table
- Question 7-8 requires joining two tables: Sales.SalesOrderDetail and Production.Product
1. What is the Name, ProductID and Weight for the item with Product Number 'RM-M823'
2. List products with weight greater than 500. For those products, show the following information: Product ID, Name, ListPrice and calculated Gross Margin (difference between list price and standard cost)
3. How many Products are there with the standard weight between 400 and 500
4. How many Yellow colored bikes are there (Bikes can be identified by the Product number starting with 'BK')
5. Find average, maximum and minimum list price for each Product line (exclude products where Product line is NULL), sort descending by Average Standard Cost.
6. Using table Sales.SalesOrderDetail find Product ID of the products where total quantity sold is less than 10 and the total amount sold is above 1000. Oder Descending based on total amount sold.
7. Join two tables: Sales.SalesOrderDetail and Productin.Product. In the output include ProductID, ProductName of the and total Sales for bikes (use column Line Total, Bikes can be identified by the Product number starting with 'BK')
8. Find what is the year with the biggest total sales for the bikes. Use subquery & CTE
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill