Four email campaigns that anchored on activity now anchor on signup, and the correlated subqueries went with them

Moving every discount campaign to one signup window turned MIN/MAX correlated subqueries into EXISTS, and made one email per account a structural property rather than a rule.