What are the codes of countries where Spanish is spoken by the largest percentage of people?
CREATE TABLE countrylanguage (CountryCode VARCHAR, Percentage INTEGER, LANGUAGE VARCHAR)
SELECT CountryCode, MAX(Percentage) FROM countrylanguage WHERE LANGUAGE = "Spanish" GROUP BY CountryCode
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE countrylanguage (CountryCode VARCHAR, Percentage INTEGER, LANGUAGE VARCHAR) Question: What are the codes of countries where Spanish is spoken by the largest percentage of people? [/INST] SELECT CountryCode, MAX(Percentage) FROM countrylanguage WHERE LANGUAGE = "Spanish" GROUP BY CountryCode </s>