SELECT, WHERE, ORDER BY

The shape of a query

Almost every query starts here:

SELECT name, price
FROM courses
WHERE is_free = false
ORDER BY price DESC
LIMIT 10;

Read it top-to-bottom: what, from where, filtered how, ordered how.