SQL Static Pivot Query:Display the name of the day, the average online order sales subtotal and average in-store order sales subtotal for each day of the week (Sunday - Saturday). You should have days of the week as headers across the top and online vs In store down the side.

sql schema table: https://i.stack.imgur.com/LMu4W.gif

AdventureWorks 2008 OLTP Schema Sales HumanResourccs Person Production Schemas Sales Purchasing Person Production AdventureWorks 2008 OLTP Schema Sales HumanResourccs Person Production Schemas Sales Purchasing Person Production