Subqueries
1 / 15
EasyOutput prediction

Subquery with IN

Given these tables:

employees:

idnamedept_id
1Alice10
2Bob20
3Carol30

departments:

idnamebudget
10Sales50000
20Eng200000
30HR40000

What does this query return?

SELECT name FROM employees
WHERE dept_id IN (
  SELECT id FROM departments WHERE budget > 100000
);

← → arrow keys to navigate

Sign in to save your progress.