[Solved] What is wrong with the following SQL query?SELECT team, position, AVG(score) FROM players GROUP BY team; | SQL

SQL - GROUP BY and HAVING

What is wrong with the following SQL query?

SELECT team, position, AVG(score) FROM players GROUP BY team;

AThe query is missing position in the GROUP BY clause.

BAVG(score) cannot be used with GROUP BY.

Cteam should not be in the SELECT clause.

DThere is no error; the query is correct.

Step-by-Step Solution

Solution:

Step 1: Identify selected columns
The query selects team, position, and AVG(score).
Step 2: Check GROUP BY clause
GROUP BY only includes team, but position is also selected without aggregation.
Step 3: Understand SQL rules
All non-aggregated columns in SELECT must be in GROUP BY.
Final Answer:
The query is missing position in the GROUP BY clause. -> Option A
Quick Check:
Non-aggregated columns must be grouped [OK]

Quick Trick: Include all non-aggregated columns in GROUP BY [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is wrong with the following SQL query?