[Solved] What will be the output of this query?SELECT emp_id FROM Employees WHERE dept_id IN (SELECT dept_id FROM Departments WHERE name LIKE '%Sales%'); | SQL

SQL - Subqueries

What will be the output of this query?

SELECT emp_id FROM Employees WHERE dept_id IN (SELECT dept_id FROM Departments WHERE name LIKE '%Sales%');

ANo results because LIKE cannot be used in subqueries

BEmployee IDs working in any department with 'Sales' in its name

CAll employee IDs regardless of department

DEmployee IDs working only in the 'Sales' department

Step-by-Step Solution

Solution:

Step 1: Analyze the subquery condition
The subquery selects dept_id for departments with names containing 'Sales'.
Step 2: Understand the outer query filter
The outer query selects emp_id where dept_id matches any from the subquery list.
Final Answer:
Employee IDs working in any department with 'Sales' in its name -> Option B
Quick Check:
IN with LIKE filters employees by matching departments [OK]

Quick Trick: IN works with subqueries returning multiple rows [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query?