Given the table Products with a column Price containing values (100, 250, 50, 400), what will the query SELECT MIN(Price), MAX(Price) FROM Products; return?

medium📝 query result Q13 of 15

SQL - Aggregate Functions

Given the table Products with a column Price containing values (100, 250, 50, 400), what will the query SELECT MIN(Price), MAX(Price) FROM Products; return?

A(400, 50)

B(50, 400)

C(100, 250)

D(0, 400)

Step-by-Step Solution

Solution:

Step 1: Identify minimum price
From the values (100, 250, 50, 400), the smallest price is 50.
Step 2: Identify maximum price
The largest price in the list is 400.
Final Answer:
(50, 400) -> Option B
Quick Check:
MIN = 50, MAX = 400 [OK]

Quick Trick: MIN returns smallest, MAX returns largest value [OK]

Common Mistakes:

MISTAKES

Mixing up MIN and MAX values
Assuming default zero minimum
Confusing order of returned values

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More SQL Quizzes

Given the table Products with a column Price containing values (100, 250, 50, 400), what will the query SELECT MIN(Price), MAX(Price) FROM Products; return?

Step 1: Identify minimum price

Step 2: Identify maximum price

Final Answer:

Quick Check:

Want More Practice?