Using GROUP BY PIVOT & UNPIVOT

Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. Explore the GROUP BY clause and how to change a table-valued expression into another table using the PIVOT and UNPIVOT operators.