[Solved] Find the issue in this SQL statement:SELECT city, state, AVG(sales) FROM sales_data GROUP BY city; — Ans: state is missing from GROUP BY clause | SQL

SQL - GROUP BY and HAVING

Find the issue in this SQL statement:

SELECT city, state, AVG(sales) FROM sales_data GROUP BY city;

Acity should not be in GROUP BY

Bstate is missing from GROUP BY clause

CAVG cannot be used with GROUP BY

DNo issue, query is valid

Step-by-Step Solution

Solution:

Step 1: Compare SELECT and GROUP BY columns
SELECT includes city and state, but GROUP BY only has city.
Step 2: Recall GROUP BY requirements
All non-aggregated columns in SELECT must be in GROUP BY to avoid errors.
Final Answer:
state is missing from GROUP BY clause -> Option B
Quick Check:
All non-aggregated SELECT columns must be grouped [OK]

Quick Trick: Match all non-aggregated SELECT 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

Find the issue in this SQL statement: