SQL Case When Repeating Conditions – Amazon Web Sevices
I have a table called country that has 2 columns: orderid, country_code. I need to do the following CASE WHEN: SELECT CASE WHEN country_code IN ('PT','IT','ES','PL','AD') THEN 'SWE' WHEN country_code IN ('MD','BG','BA','SI','HR','ME','RO','RS') THEN 'SEE' WHEN country_code IN ('CI','GH','MA','NG','UG','KE','TN') THEN 'AFRICA'…