[Solved] Find the issue in this query:SELECT * FROM sales WHERE product_id IN SELECT product_id FROM products WHERE price > 100; | SQL

SQL - Subqueries

Find the issue in this query:

SELECT * FROM sales WHERE product_id IN SELECT product_id FROM products WHERE price > 100;

AUsing '*' in SELECT is invalid

BMissing parentheses around the subquery

CSubquery returns no rows

DIncorrect use of IN keyword

Step-by-Step Solution

Solution:

Step 1: Check subquery syntax
The subquery after IN must be enclosed in parentheses.
Step 2: Identify missing parentheses
The query misses parentheses around the subquery, causing syntax error.
Final Answer:
Missing parentheses around the subquery -> Option B
Quick Check:
Subquery in WHERE with IN needs parentheses [OK]

Quick Trick: Always put subquery in parentheses after IN [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the issue in this query: