MySQL 9.0 Release Notes
Aggregate functions operate on sets of values. They are often used
with a GROUP BY
clause to group values into
subsets. This section describes most aggregate functions. For
information about aggregate functions that operate on geometry
values, see Section 14.16.12, “Spatial Aggregate Functions”.