Preview:
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
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter