Question
Solution
SQL
SELECT name
FROM employees e1
WHERE EXISTS (
SELECT 1
FROM employees e2
WHERE e2.id = e1.id AND e2.department = 'HR'
);
3/3 test cases passed
No hidden test cases
SELECT name
FROM employees e1
WHERE EXISTS (
SELECT 1
FROM employees e2
WHERE e2.id = e1.id AND e2.department = 'HR'
);
3/3 test cases passed
No hidden test cases