Group rows and count them

sql

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

Explanation

A common reporting pattern for order states, ticket states, and similar grouped data.

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

Return the total number of rows in a table.

Open In sheetsqlsame section

Keep only groups that meet aggregate criteria.

Open In sheetsqlsame section

Calculate totals and averages.

Open In sheetsqlsame section

Rank a user's orders by recency.

Compute cumulative revenue by day.

Calculate day-over-day change.