Use Adventure Works Database

 

Question 1 will be Sales.SalesOrderDetail table

Questtion 2-3requires joining two tables: Sales.SalesOrderDetail and Production.Product

 

 

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

 

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

 

3. Find what is the year with the biggest total sales for the bikes. Use subquery & CTE