Find the mistake in this query: SELECT AVG(price), MIN(price), MAX(price) FROM products GROUP BY price;

medium📝 Debug Q7 of 15

PostgreSQL - Aggregate Functions and GROUP BY

Find the mistake in this query: SELECT AVG(price), MIN(price), MAX(price) FROM products GROUP BY price;

AMissing WHERE clause

BGROUP BY price causes each group to have one price, making AVG redundant

CAVG requires a HAVING clause

DMIN and MAX cannot be used with GROUP BY

Step-by-Step Solution

Solution:

Step 1: Analyze GROUP BY effect
Grouping by price means each group has one price value.
Step 2: Understand AVG behavior
AVG(price) over single-value groups equals that value, so AVG is redundant.
Final Answer:
GROUP BY price causes each group to have one price, making AVG redundant -> Option B
Quick Check:
GROUP BY price groups single values [OK]

Quick Trick: GROUP BY single column makes aggregates trivial [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free