Lesson 19 — GROUP BY + HAVING + ORDER

The full query order

A complete query is written in this order: SELECT → FROM → (JOIN) → WHERE → GROUP BY → HAVING → ORDER BY → LIMIT. It helps to read it in the order the database runs it: pick rows (FROM, WHERE), group them, filter groups (HAVING), compute SELECT, then sort and cut.

SELECT city, AVG(price) FROM sales
WHERE year = 2026 GROUP BY city HAVING COUNT(*) >= 2
ORDER BY AVG(price) DESC LIMIT 2

Why it matters: most "my query gives an error" problems are clauses in the wrong order. Knowing the order makes complex reports easy to write.