Cacher is the code snippet organizer for pro developers

SELECT s.EmailAddress, s.SubscriberKey, s.Status,  
CASE WHEN s.Status = 'unsubscribed' THEN s.DateUnsubscribed ELSE b.EventDate END AS Date 
FROM _Subscribers s
LEFT JOIN _bounce b ON b.SubscriberKey = s.SubscriberKey
WHERE s.Status = 'unsubscribed' OR s.Status = 'held'
AND ( b.EventDate > dateadd(m,-1,getdate())  OR s.DateUnsubscribed > dateadd(m,-1,getdate()))