I'm trying to make a query that checks to see if a user's value for [PaperlessBillingOptIn] is equal to "N" for a promotional email for a new feature.
However, because users can have multiple records in our database (attached to their policies), they may sometimes have one record with "Y" and one with "N."
In this case, we don't want to send to a user whose PaperlessBillingOptIn is "N" if they have another record for which it is "Y."
How can this be accomplished within an Automation Studio query activity? It seems like doing normal counts doesn't work here.