(Solved) : Activity Using Adventureworks Database Link Download Sample Database Needed Https Archivec Q30342858 . . . .

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.–What are theaverage sales for in-store and online purchases for each– day ofthe week?–Display the name of the day, the average sales subtotalfor online orders,– and average sales subtotal for in-store ordersfor each day of the week– (Sunday, Monday, Tuesday, Wednesday,Thursday, Friday, Saturday). The days– of the week are to be theheaders across the top and 0 and 1 for in-store– and online forthe rows.– You can use a CASE statement to replace the