Aggregation

Aggregation · Basic

COUNT

counting rows or non-null values.

Aggregation · Basic

SUM

Adds numeric values, commonly for totals and amounts.

Aggregation · Intermediate

GROUP BY

Groups rows by one or more columns for aggregation.

Aggregation · Intermediate

HAVING

Filters grouped aggregate results, usually after GROUP BY.

Aggregation · Basic

AVG

Calculates the average value of a numeric column.

Aggregation · Basic

MAX

finding the maximum value.

Aggregation · Basic

MIN

finding the minimum value.

Aggregation · Intermediate

COUNT DISTINCT

counting distinct values

Aggregation · Intermediate

GROUP_CONCAT

concatenating values within each group