Using GROUP BY, PIVOT, & UNPIVOT

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.