Advertisement
Guest User

Untitled

a guest
Oct 16th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. SELECT
  2. o.SubscriberKey,
  3. ea.Gender
  4. FROM _Open o
  5. INNER JOIN ENT._EnterpriseAttribute ea ON o.SubscriberID = ea._SubscriberID
  6. WHERE ea.Gender = 'Female'
  7. AND o.EventDate > dateadd(d,-7,getdate())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement