[Solved] Find the issue in this SQL query:SELECT country, AVG(age) FROM users; — Ans: Missing GROUP BY clause for the non-aggregated column | SQL

SQL - GROUP BY and HAVING

Find the issue in this SQL query:

SELECT country, AVG(age) FROM users;

AQuery should use WHERE instead of SELECT

BAVG() cannot be used with numeric columns

Ccountry should be inside an aggregate function

DMissing GROUP BY clause for the non-aggregated column

Step-by-Step Solution

Solution:

Step 1: Check aggregation rules
Columns in SELECT must be aggregated or included in GROUP BY.
Step 2: Analyze query
country is non-aggregated but not in GROUP BY, causing error.
Final Answer:
Missing GROUP BY clause for the non-aggregated column -> Option D
Quick Check:
Non-aggregated columns require GROUP BY [OK]

Quick Trick: Non-aggregated columns must be grouped [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 issue in this SQL query: