Aggregate Functions
Learn how SQLite aggregate functions summarize many rows into meaningful metrics like counts, totals, and averages.
COUNT
Count rows and non-null values in SQLite using COUNT(*), COUNT(column), and grouped counts.
SUM
Calculate totals with SQLite SUM across entire tables or per group for reporting and analysis.
AVG
Compute average values in SQLite with AVG and understand null handling in mean calculations.
MIN
Find the smallest value in SQLite datasets using MIN for numeric, date, or text comparisons.
MAX
Find the largest value in SQLite data with MAX for amounts, timestamps, and ranked metrics.
GROUP BY
Group SQLite rows by one or more columns and calculate per-group summaries with aggregate functions.
HAVING Clause
Filter grouped results in SQLite using HAVING, and understand when to use WHERE versus HAVING.