question: How many students are enrolled in the team nicknamed Comets?
answer: SELECT enrollment FROM table_28243691_2 WHERE team_nickname = "Comets"
context: CREATE TABLE table_28243691_2 (enrollment VARCHAR, team_nickname VARCHAR)