Skip to content

Instantly share code, notes, and snippets.

@slava-basko
slava-basko / gist:3c9e9d199bb9a762dba5d5ffd926918f
Created August 22, 2019 13:04
SELECT countries alpha-3 to alpha-2
select CASE alpha3
WHEN 'ABH' then 'AB'
WHEN 'AND' then 'AD'
WHEN 'ARE' then 'AE'
WHEN 'AFG' then 'AF'
WHEN 'ATG' then 'AG'
WHEN 'AIA' then 'AI'
WHEN 'ALB' then 'AL'
WHEN 'ARM' then 'AM'
WHEN 'AGO' then 'AO'