# Aggregating Data

A critical part of working with databases is creating useful reports from stored data. In this chapter, we will examine aggregate functions to help us create those reports.

Updated: November 16, 2026

## [Common SQL Functions](https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/common-sql-functions)

1. [Common SQL Functions](https://www.ask-codey.com/lessons/common-sql-functions) (Apprentice): How to use MySQL's CONCAT() to join text from several columns and COALESCE() to replace NULL with a default value.
2. [More MySQL Functions](https://www.ask-codey.com/lessons/more-mysql-functions) (Apprentice): The MySQL functions a developer reaches for every week, grouped by job. Clean up and take apart text, round numbers, work with dates, and handle NULL and empty text.

## [Aggregate Functions](https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/aggregate-functions)

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/chapters/aggregating-data
