[Solved] Identify the error in this query:SELECT name FROM employees WHERE salary > SELECT AVG(salary) FROM employees; | PostgreSQL

PostgreSQL - Subqueries in PostgreSQL

Identify the error in this query:

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

AAVG function cannot be used in WHERE clause

BIncorrect table name

Csalary column does not exist

DMissing parentheses around the subquery

Step-by-Step Solution

Solution:

Step 1: Check subquery syntax
Subqueries must be enclosed in parentheses to be valid.
Step 2: Identify missing parentheses
The query lacks parentheses around the subquery, causing syntax error.
Final Answer:
Missing parentheses around the subquery -> Option D
Quick Check:
Subqueries require parentheses () [OK]

Quick Trick: Always wrap subqueries in parentheses to avoid syntax errors [OK]

Common Mistakes:

Master "Subqueries in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this query: