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