Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT
o.SubscriberKey,
ea.Gender
FROM _Open o
INNER JOIN ENT._EnterpriseAttribute ea ON o.SubscriberID = ea._SubscriberID
WHERE ea.Gender = 'Female'
AND o.EventDate > dateadd(d,-7,getdate())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment