[Solved] Find the mistake in this query:SELECT city, COUNT(*) FROM customers GROUP BY city ORDER BY city_name ASC; | SQL

SQL - GROUP BY and HAVING

Find the mistake in this query:

SELECT city, COUNT(*) FROM customers GROUP BY city ORDER BY city_name ASC;

AMissing WHERE clause before GROUP BY

BCOUNT(*) cannot be used without alias

CGROUP BY must include COUNT(*)

DORDER BY uses a column 'city_name' not in SELECT or GROUP BY

Step-by-Step Solution

Solution:

Step 1: Check ORDER BY column
ORDER BY references 'city_name' which is not in SELECT or GROUP BY.
Step 2: Identify error
ORDER BY must use columns from SELECT or GROUP BY; 'city_name' causes error.
Final Answer:
ORDER BY uses a column 'city_name' not in SELECT or GROUP BY -> Option D
Quick Check:
ORDER BY columns must be in SELECT or GROUP BY [OK]

Quick Trick: ORDER BY columns must exist in SELECT or 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 mistake in this query: