Identify the error in the following SQL query: SELECT COUNT(*) FROM orders WHERE COUNT(order_id) > 5;

medium📝 Debug Q6 of 15

SQL - Aggregate Functions

Identify the error in the following SQL query: SELECT COUNT(*) FROM orders WHERE COUNT(order_id) > 5;

AMissing GROUP BY clause

BCOUNT(*) should be COUNT(order_id)

CCOUNT cannot be used in WHERE clause

DCOUNT(order_id) should be COUNT(*)

Step-by-Step Solution

Solution:

Step 1: Understand aggregate functions usage
Aggregate functions like COUNT cannot be used directly in WHERE clause.
Step 2: Correct usage of COUNT in filtering
Use HAVING clause to filter on aggregate results, not WHERE.
Final Answer:
COUNT cannot be used in WHERE clause -> Option C
Quick Check:
Aggregate functions not allowed in WHERE [OK]

Quick Trick: Use HAVING, not WHERE, for aggregate filters [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes