Table: countries_iso3166
Columns: english_short_name_upper_lower_case
alpha_2_code
alpha_3_code
numeric_code
iso_3166_2_codes

Question: What is the Alpha 2 code for the area also known as TCA?
SQL: SELECT "alpha_2_code" FROM countries_iso3166 WHERE "alpha_3_code" = 'TCA'

Question: What is the Alpha 3 code for the area also known as FO?
SQL: SELECT "alpha_3_code" FROM countries_iso3166 WHERE "alpha_2_code" = 'FO'

Question: What is the alpha 2  code for the area also known as NZL?
SQL: SELECT "alpha_2_code" FROM countries_iso3166 WHERE "alpha_3_code" = 'NZL'

Question: What is the ISO for South Sudan?
SQL: SELECT "iso_3166_2_codes" FROM countries_iso3166 WHERE "english_short_name_upper_lower_case" = 'South Sudan'

Question: What is the Alpha 2 code for Papua New Guinea?
SQL: SELECT "alpha_2_code" FROM countries_iso3166 WHERE "english_short_name_upper_lower_case" = 'Papua New Guinea'

Question: What is the number reference for LIE?
SQL: SELECT "numeric_code" FROM countries_iso3166 WHERE "alpha_3_code" = 'LIE'