Learning SQL GROUP BY with Excel Pivot Table

This video uses the AdventureWorks database to show how aggregation functions are generated in T-SQL across values in another field with the GROUP BY clause. This video is part of a series that uses various approaches to teach the GROUP BY clause in T-SQL. In this particular video, we use the Excel Pivot Table to replicate the results of a SQL query with a GROUP BY.