Aftermarket_Reporting_Master - Step 1

SELECT s.SubscriberKey, s.eventdate AS SendDate, LanguageCode,

CASE 
WHEN Additional_Information__c  = 'Financing Options' THEN  'Finance'
WHEN  Additional_Information__c = 'Extended Protection' THEN 'Protection'
WHEN  Additional_Information__c = 'Extended Protection or Insurance Options' THEN 'Protection'
WHEN  Additional_Information__c = 'Parts Information' THEN 'Parts'
WHEN  Additional_Information__c = 'Service Options' THEN 'Service'
WHEN  Additional_Information__c is null THEN 'Default'
ELSE 'Default' END as EmailType,

EmailName, s.TriggeredSendCustomerKey

FROM _Sent s
LEFT JOIN _Job j ON j.JobID = s.JobID
LEFT JOIN [ep_en_us_aftermarket_nurture_p-2511_0221] m ON m.SubscriberKey = s.SubscriberKey

Where s.TriggeredSendCustomerKey in ('80510','142092','142093')
AND DATEDIFF(m,getdate(),s.eventdate) = -1