A. Calculates the average value for each group of rows
B. Counts the number of rows in each group
C. Filters groups based on a condition
D. Retrieves the maximum value in each group

Solution

A. Calculates the average value for each group of rows