What is the total number of countries where Spanish is spoken by the largest percentage of people?
CREATE TABLE countrylanguage (Percentage INTEGER, CountryCode VARCHAR, LANGUAGE VARCHAR)
SELECT COUNT(*), 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 (Percentage INTEGER, CountryCode VARCHAR, LANGUAGE VARCHAR) Question: What is the total number of countries where Spanish is spoken by the largest percentage of people? [/INST] SELECT COUNT(*), MAX(Percentage) FROM countrylanguage WHERE LANGUAGE = "Spanish" GROUP BY CountryCode </s>