Aggregates perform calculations on groups of values and return a single result. Commonly used for reporting, analytics, and dashboards.
COUNT()
— Counts number of recordsSUM()
— Adds up valuesAVG()
— Calculates averageMAX()
— Returns highest valueMIN()
— Returns lowest valueGROUP BY
to get grouped summaries.