# Common Aggregate Functions

COUNT counts rows or values, SUM adds them, AVG averages them, and MIN and MAX find the smallest and largest. All but COUNT(\*) skip NULL.

![Cheat sheet: Common Aggregate Functions](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/74295caa226e4c0ab5e33fb31b874a7e.webp)

- Category: SQL
- Level: Apprentice
- Tags: AVG, COUNT (database), MAX (database), MIN (database), sql, SUM (database), t-sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/aggregate-functions-in-t-sql-common-aggregate-functions-cheat-sheet