Predict Simple SELECT
Predict Output Beginner
Question
Given a table `users` with columns (id, name), what does this query return if the table has 3 rows?
Code
SELECT COUNT(*) FROM users;
Hint
COUNT(*) counts all rows.
Explanation
COUNT(*) returns the total number of rows in the table. With 3 rows, the result is 3.
Related Resources
Related Lessons
- Aggregations
Learn COUNT.
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.