Table: countries_capitals
Columns: country_exonym
capital_exonym
country_endonym
capital_endonym
official_or_native_language_s_alphabet_script

Question: What is the capital (endonym) where Douglas is the Capital (exonym)?
SQL: SELECT "capital_endonym" FROM countries_capitals WHERE "capital_exonym" = 'Douglas'

Question: How many countries (endonym) has the capital (endonym) of Jakarta?
SQL: SELECT COUNT("country_endonym") FROM countries_capitals WHERE "capital_endonym" = 'Jakarta'

Question: What is the country (exonym) where the official or native language(s) (alphabet/script) is Icelandic?
SQL: SELECT "country_exonym" FROM countries_capitals WHERE "official_or_native_language_s_alphabet_script" = 'Icelandic'

Question: In which country (endonym) is Irish English the official or native language(s) (alphabet/script)?
SQL: SELECT "country_endonym" FROM countries_capitals WHERE "official_or_native_language_s_alphabet_script" = 'Irish English'

Question: Which country (exonym) is the country (endonym) isle of man ellan vannin?
SQL: SELECT "country_exonym" FROM countries_capitals WHERE "country_endonym" = 'Isle of Man Ellan Vannin'