AVG
An Aggregate Function giving the mean of the values, ignoring NULLs. So with NULLs present it is not the sum divided by the row count.
SELECT rating, AVG(rental_rate) AS avg_rate
FROM film
GROUP BY rating;
When to use
PS 03 Q1 filters films with HAVING AVG(rental_rate) > 3.5, and PS 04 Q1 nests AVG over per-customer rental counts using a Derived Table.
See PS 03.