human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Country ( exonym ), Capital ( exonym ), Country ( endonym ), Capital ( endonym ), Official or native language(s) (alphabet/script)
###Question: What is the English name given to the city of St. John's?
gpt
SELECT Capital ( exonym ) FROM table WHERE Capital ( endonym ) = St. John's