Creating grouped aggregations

You can calculate statistics for each group using GROUP BY. For example, you can calculate the maximum value for each state using the following query:

SELECT State, MAX(DurationSeconds)
FROM Incidents
GROUP BY State

To filter even further, for example, to find the values for states where the maximum value is greater than 10, you can use the HAVING clause.

Write a T-SQL query to calculate the average, minimum, and maximum values of the DurationSeconds column grouped by Shape. You need to select an additional column. What is it?

Exercise

Creating grouped aggregations

Instructions 1/2