The Three Largest Receipts

The Three Largest Receipts

QUERY reminds you: LIMIT shrinks the output, not the bill — you pay for the columns read. So a query must carry exactly as many columns as the answer needs. Output the three most expensive purchases (event_name = 'purchase'): only event_id, city and revenue, ordered by revenue descending.

Any row order

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid