user: Question: What is the English name given to the city of St. John's?
Columns: ['Country ( exonym )', 'Capital ( exonym )', 'Country ( endonym )', 'Capital ( endonym )', 'Official or native language(s) (alphabet/script)']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Afghanistan', 'Kabul', 'Afghanestan افغانستان', 'Kaalu كابل', 'Pashto / Dari ( Arabic script )']
SQL:

assistant: SELECT "Capital ( exonym )" FROM "Table" WHERE "Capital ( endonym )" = 'St. John''s';