Group by a column

sql

SELECT status, COUNT(*) AS total
FROM orders
GROUP BY status;

Explanation

All non-aggregated selected columns must appear in GROUP BY.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Aggregation and Grouping

Aggregate by more than one dimension.

Open In sheetsqlsame section

Apply conditions after aggregation.

Open In sheetsqlsame section

Return total row count.

Open In sheetsqlsame section

Calculate summary metrics.

Open In sheetsqlsame section

Return all columns from a table.

Return rows matching an exact value.