Who isn't a manager?

Question

Accepted Answer

The subquery returns ('Alice', 'Dave'). NOT IN excludes employees whose name appears in that list. Alice is excluded. Bob and Carol are not in the managers list and are returned. Dave is in managers but not in employees, so he is irrelevant to the outer query.