[Solved] Identify the error in this correlated subquery:SELECT name FROM employees e WHERE salary > (SELECT AVG(salary) FROM employees); | SQL

SQL - Subqueries

Identify the error in this correlated subquery:

SELECT name FROM employees e WHERE salary > (SELECT AVG(salary) FROM employees);

AThe subquery is not correlated but used as if it is

BMissing alias for the subquery

CIncorrect use of aggregate function AVG

DSyntax error due to missing WHERE clause in subquery

Step-by-Step Solution

Solution:

Step 1: Check subquery correlation
The subquery does not reference outer query columns, so it is not correlated.
Step 2: Understand usage context
The query uses the subquery as a simple scalar subquery, not correlated, so no error but no correlation.
Final Answer:
The subquery is not correlated but used as if it is -> Option A
Quick Check:
Subquery without outer reference = not correlated [OK]

Quick Trick: Correlation requires outer query column reference [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this correlated subquery: