//Select Distinct Subscriber by signup date

SELECT DISTINCT a.EmailAddress as email, b.signup_date
FROM _Subscribers a
JOIN (SELECT DISTINCT c.EmailAddress as email, MIN(c.DateJoined) as signup_date
FROM _Subscribers c GROUP BY c.EmailAddress, c.DateJoined) AS b
ON a.EmailAddress = b.email