Cacher is the code snippet organizer for pro developers

SELECT a.SubscriberID, a.DateUndeliverable, a.DateJoined, a.DateUnsubscribed, a.Domain, a.EmailAddress, a.BounceCount, a.SubscriberKey, a.SubscriberType, a.Status, a.Locale 
FROM _Subscribers a
INNER JOIN 
  (SELECT EmailAddress,
    MAX(DateJoined) as DateJoined
  FROM _Subscribers
  GROUP BY EmailAddress 
) AS b
  ON a.EmailAddress = b.EmailAddress 
  AND a.DateJoined = b.DateJoined
  
  WHERE a.EmailAddress NOT LIKE '%growingminds%'