SQLRepPath
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
00/60 solved

The Basics · ORDER BY · LIMIT

4. Three biggest orders

Concept: ORDER BY · LIMITshow

LIMIT n keeps only the first n rows of the result. It runs after ORDER BY, so 'sort, then cut' gives you a top-N list.

Example (different data):

SELECT title, views
FROM videos
ORDER BY views DESC
LIMIT 5;

Your task

The CEO wants to personally thank the customers behind the three largest orders. Refunded and pending orders don't count.

Return id, customer_id and amount of the 3 largest completed orders, largest first.

Solution unlocks after 3 more tries

Starting Postgres in your browser…

query.sql
Output

Write a query and press Run Query (Ctrl/⌘ + Enter).