Table schema:
CREATE TABLE table_28243691_2 (enrollment VARCHAR, team_nickname VARCHAR)

Question: How many students are enrolled in the team nicknamed Comets?
SQL: SELECT enrollment FROM table_28243691_2 WHERE team_nickname = "Comets"