Nobody Comes Back

employees:

id name manager_id
1 Ada NULL
2 Bob 1
3 Cy 1
4 Dee 2

The intent is "list everyone who manages nobody", so Cy and Dee.

SELECT name
FROM employees
WHERE id NOT IN (SELECT manager_id FROM employees);

What does it actually return?

A

An error, because the subquery returns a null

B

Zero rows

C

Cy and Dee

D

Ada, Cy and Dee