Intermediate · SQL · Aggregation

Order count and revenue by status

Commonly asked: QA data-validation rounds · ~6 min

Return status, orders (count) and revenue (sum of total, rounded to 2) for each order status, sorted by orders descending then status.