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