[Solved] Identify the error in the following query:SELECT * FROM sales WHERE customer_id IN SELECT id FROM customers WHERE country = 'USA'; | PostgreSQL

PostgreSQL - Subqueries in PostgreSQL

Identify the error in the following query:

SELECT * FROM sales WHERE customer_id IN SELECT id FROM customers WHERE country = 'USA';

AIncorrect table name 'sales'

BMissing parentheses around the subquery after IN

CUsing IN instead of EXISTS

DNo error, query is correct

Step-by-Step Solution

Solution:

Step 1: Check syntax of IN with subquery
The subquery must be enclosed in parentheses after IN.
Step 2: Analyze the query
The query lacks parentheses around the subquery, causing a syntax error.
Final Answer:
Missing parentheses around the subquery after IN -> Option B
Quick Check:
IN requires parentheses around subqueries [OK]

Quick Trick: Always use parentheses around subqueries with IN [OK]

Common Mistakes:

Master "Subqueries in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in the following query: