Skip to content

Instantly share code, notes, and snippets.

@zuzannamj
Created September 27, 2019 20:20
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save zuzannamj/3b739f9656d292852f8b9e86a8182e63 to your computer and use it in GitHub Desktop.
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