Aggregate Function
Also known as · Aggregate Functions
A function that summarises many rows into one value: COUNT, SUM, AVG, MIN and MAX. It is evaluated after grouping, so it cannot appear in WHERE.
SELECT rating, AVG(rental_rate)
FROM film
GROUP BY rating
HAVING AVG(rental_rate) > 3;
When to use
Used in PS 03 (average rental rate per film, totals per city) and in PP 01 Q4 and PP 02 Q4, where a condition on an aggregate such as a sum must go in HAVING rather than WHERE.
See PP 01.