100% activation, three inactive users: a SQL interview trap

Your query returns 100% activation for both signup groups. It runs without an error. Three of the ten...