SELECT mst.SubscriberKey, mst.EmailAddress,mst.Consent_Level_Summary__c,
CASE WHEN Mailing_Country__c = 'US' THEN 'NA'
WHEN Mailing_Country__c = 'MX' THEN 'NA'
WHEN Mailing_Country__c = 'CA' THEN 'NA'
ELSE 'OTHER'
END as SegmentRegion
FROM ep_mr_en_us_w170049_MASTER mst
WHERE SegmentRegion is null