# Aggregate Functions

Aggregate Functions: Calculations vs Aggregations, Common Aggregate Functions, Grouping Aggregations.

Updated: November 16, 2026

1. [Calculations vs Aggregations](https://www.ask-codey.com/lessons/aggregate-functions-calculations-vs-aggregations) (Apprentice): The difference between a calculation, which works on the values in one row, and an aggregate function, which turns many rows into one value.
2. [Common Aggregate Functions](https://www.ask-codey.com/lessons/aggregate-functions-common-aggregate-functions) (Apprentice): What COUNT, SUM, AVG, MIN and MAX return, and how each one treats NULL values.
3. [Grouping Aggregations](https://www.ask-codey.com/lessons/aggregate-functions-grouping-aggregations) (Journeyman): How GROUP BY returns one aggregate row per group, and how HAVING filters those groups where WHERE filters rows.

Source: https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/aggregate-functions
