Find the Clause Order Mistake
Find the Mistake Medium
Question
This query has a clause ordering error. Find and fix it:
Code
SELECT * FROM users
LIMIT 10
WHERE age > 18;
Hint
WHERE must come before LIMIT.
Explanation
The clauses are in the wrong order. The correct order is: SELECT → FROM → WHERE → ORDER BY → LIMIT. Fix: SELECT * FROM users WHERE age > 18 LIMIT 10;.
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.