Which name survives the subtraction?

Question

Accepted Answer

EXCEPT (MINUS in Oracle) returns rows from the first query that do not appear in the second query. Bob and Carol appear in active_users and are removed. Alice is in all_users but not in active_users, so she is returned. This is the 'find inactive users' pattern - rows in A that are not in B.