WHERE Filter
Predict Output Beginner
Question
What does this SQL produce?
Code
-- users: (1,"Ada",30), (2,"Bob",20), (3,"Cy",30)
SELECT name FROM users WHERE age = 30;
Hint
WHERE filters rows where age equals 30.
Explanation
The WHERE clause filters rows where age = 30. Both Ada (age 30) and Cy (age 30) match. Bob (age 20) is excluded. Result: Ada, Cy.
Related Resources
Related Lessons
- WHERE
Learn WHERE.
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.