Find the ORDER BY Mistake
Find the Mistake Easy
Question
This query has an error. Find and fix it:
Code
SELECT * FROM users ORDER BY name DESC LIMIT 10;
Hint
Look carefully at the clause order.
Explanation
This query is actually correct! The clause order is right: SELECT → FROM → ORDER BY → LIMIT. ORDER BY name DESC LIMIT 10 is valid and returns the last 10 users alphabetically.
Related Resources
Related Lessons
- Select Queries
Learn clause order.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.