COUNT, SUM, AVG, MIN & MAX
Learn COUNT, SUM, AVG, MIN & MAX (Aggregate Functions, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Aggregate functions collapse many rows into one value: COUNT (how many), SUM (total), AVG (mean), MIN and MAX (extremes). Without GROUP BY the whole table becomes one group.