CREATE TABLE table_28243691_2 (enrollment VARCHAR2, team_nickname VARCHAR2)

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