It doesn't drop the account if if doesn't contains at least one user that only belongs to this account (i.e. the CTE returns no row).