Tracking Inactive Subscribers in SFMC: Updates Subscriber_Last_Open with _Subscribers and Last Sent

Updates Subscriber_Last_Open with _Subscribers and Last Sent

SELECT
  e.EmailAddress,
  e.SubscriberID,
  e.Status,
  e.DateJoined,
  e.DateUnsubscribed,
  MAX(d.EventDate) AS 'LastSentDate',
  COUNT(d.SubscriberID) AS Sent
FROM _Subscribers e
JOIN _Sent d
ON e.SubscriberID = d.SubscriberID
GROUP BY e.SubscriberID, e.EmailAddress, e.Status, e.DateJoined, e.DateUnsubscribed
HAVING COUNT(d.SubscriberID) > 0