[Solved] Find the error in this query:SELECT team, AVG(score) FROM players WHERE AVG(score) > 80 GROUP BY team; | SQL

SQL - GROUP BY and HAVING

Find the error in this query:

SELECT team, AVG(score) FROM players WHERE AVG(score) > 80 GROUP BY team;

AMissing GROUP BY clause

BUsing AVG(score) in WHERE clause

CIncorrect SELECT syntax

DHAVING clause missing after GROUP BY

Step-by-Step Solution

Solution:

Step 1: Identify WHERE clause limitations
WHERE cannot use aggregate functions like AVG because it filters rows before aggregation.
Step 2: Correct clause usage
To filter groups by AVG(score), use HAVING instead of WHERE.
Final Answer:
Using AVG(score) in WHERE clause -> Option B
Quick Check:
Aggregate filters require HAVING, not WHERE [OK]

Quick Trick: Aggregate functions cannot be used in WHERE clause [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the error in this query: