H5saUWg1

1SELECT DISTINCT  
2m.SubscriberKey
3, m.EmailAddress 
4FROM _Open as o 
5Inner Join [Master Subsciber] as m on (o.SubscriberKey = m.SubscriberKey)
6WHERE 
7o.DOMAIN = 'gmail.com' 
8AND o.EventDate Between DATEADD(d, -30, GETDATE()) and GETDATE()