T-SQL: Over() and Partition By Show how to use OVER and PARTITION BY to get groups of data with aggregation.