For this activity, we will using the AdventureWorksdatabase.
(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 aresold each month for each category?–List each category name, year,and the number of units sold by month. The– names of the monthsare to be headers across the top and category names– and yearsdown the rows. Order by category name first and then year.
Expert Answer
An answer will be send to you shortly. . . . .