MIN MAX
Predict Output Easy
Question
What does this SQL produce?
Code
-- prices: 10, 50, 30, 20
SELECT MIN(price), MAX(price) FROM products;
Hint
MIN returns the smallest, MAX the largest value.
Explanation
MIN(price) returns the smallest price (10). MAX(price) returns the largest price (50). Both ignore NULL values.
Related Resources
Related Lessons
- Aggregations
Learn aggregations.
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.