Which fix removes the bug?
SELECT name FROM users WHERE age > 18 AND < 30; -- syntax error
- Wrap it:
age > (18 AND < 30) - Swap the
ANDfor anOR - Repeat the column:
AND age < 30 - Write it as
age > 18 < 30
Each side of AND must be a complete condition, so the column has to be named again (or use
Play Problem Solving ▸
age BETWEEN 19 AND 29).