MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
Aggregate functions operate on sets of values. They are often used with a GROUP BY clause to group values into subsets.
GROUP BY