Identify the error in this query: SELECT AVG FROM Orders;

medium📝 Debug Q6 of 15

SQL - Aggregate Functions

Identify the error in this query: SELECT AVG FROM Orders;

AAVG cannot be used without GROUP BY

BAVG is not a valid function

CMissing parentheses after AVG

DTable name is incorrect

Step-by-Step Solution

Solution:

Step 1: Check AVG() function syntax
AVG() requires parentheses with a column name inside, e.g., AVG(column).
Step 2: Identify missing parentheses
The query uses AVG without parentheses, causing syntax error.
Final Answer:
Missing parentheses after AVG -> Option C
Quick Check:
AVG() needs parentheses [OK]

Quick Trick: Always use AVG(column) with parentheses [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