Buyer revenue derived table

Using a derived table in FROM, return buyer_id and revenue for buyers whose total revenue is at least 200. Order by revenue descending, then buyer_id ascending.

Aggregate in a FROM subquery aliased buyer_totals, then filter revenue >= 200 in the outer SELECT.

Sample input

ordersAll-status buyer totals: 1→330, 2→650, 3→290, 4→190, 6→700.

order_id	buyer_id	total_amount
1001	1	80
1004	1	220
1009	1	30
1003	4	40
1008	4	150

Expected output

Expected outputBuyers whose total revenue is at least 200 (buyer 4 at 190 drops out), highest first.

buyer_id	revenue
6	700
2	650
1	330
3	290

Constraints

Aggregate SUM(total_amount) per buyer inside a FROM subquery (a derived table), then filter revenue >= 200 in the outer query. Order by revenue DESC, buyer_id ASC.

Expected skills

Derived tables, aggregation, and outer-query filtering on an aggregate.

SQL

AI evaluation

Run the SQL query to inspect preview rows.