What was the highest amount of people that attended the elgin city team?
CREATE TABLE table_11206916_1 (highest VARCHAR, team VARCHAR)
SELECT COUNT(highest) FROM table_11206916_1 WHERE team = "Elgin City"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11206916_1 (highest VARCHAR, team VARCHAR) Question: What was the highest amount of people that attended the elgin city team? [/INST] SELECT COUNT(highest) FROM table_11206916_1 WHERE team = "Elgin City" </s>