How many students are enrolled in the team nicknamed Comets?
CREATE TABLE table_28243691_2 (enrollment VARCHAR, team_nickname VARCHAR)
SELECT enrollment FROM table_28243691_2 WHERE team_nickname = "Comets"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28243691_2 (enrollment VARCHAR, team_nickname VARCHAR) Question: How many students are enrolled in the team nicknamed Comets? [/INST] SELECT enrollment FROM table_28243691_2 WHERE team_nickname = "Comets" </s>