Group BY « Select Query « SQL Server / T-SQL

1.GROUP BY clause with an aggregator 'SUM()'
2.Combine MIN function with group by
3.Combine MAX function with group by
4.GROUP BY builds different groups for all possible values (NULL, too!)
5.When grouping on more than one column, every unique combination of grouped values produces a row in the result set
6.Count() and Sum() with group by and column alias
7.Subquery as one column
8.Simple 'group by' demo
9.Count with 'group by'