For this activity, we will using the AdventureWorks database.

(Here is the link to download the sample database if needed. https://archive.codeplex.com/?p=msftdbprodsamples

Select the oltp file)

--Query 1--Use PIVOT to complete this query.--How many units are sold each month for each category?--List each category name, year, and the number of units sold by month. The-- names of the months are to be headers across the top and category names-- and years down the rows. Order by category name first and then year.