Get all Subscribers based on their status

Get all Subscribers based on their status.sql

-- Get all Active
SELECT sb.SubscriberKey, sb.EmailAddress, sb.Status, ea.[First Name], ea.[Last Name], ea.Gender, ea.[Date of Birth], ea.Address, ea.Suburb, ea.State, ea.Postcode, sb.DateJoined 
FROM _Subscribers sb 
LEFT JOIN _EnterpriseAttribute ea ON sb.SubscriberID=ea._SubscriberID  
WHERE sb.Status = 'Active'


-- Get all Unsubscribe
SELECT sb.SubscriberKey, sb.EmailAddress, sb.Status, ea.[First Name], ea.[Last Name], ea.Gender, ea.[Date of Birth], ea.Address, ea.Suburb, ea.State, ea.Postcode, sb.DateJoined 
FROM _Subscribers sb 
LEFT JOIN _EnterpriseAttribute ea ON sb.SubscriberID=ea._SubscriberID  
WHERE sb.Status = 'Unsubscribe'


-- Get all Held
SELECT sb.SubscriberKey, sb.EmailAddress, sb.Status, ea.[First Name], ea.[Last Name], ea.Gender, ea.[Date of Birth], ea.Address, ea.Suburb, ea.State, ea.Postcode, sb.DateJoined 
FROM _Subscribers sb 
LEFT JOIN _EnterpriseAttribute ea ON sb.SubscriberID=ea._SubscriberID  
WHERE sb.Status = 'Held'