user: Question: How many students are enrolled in the team nicknamed Comets?
Columns: ['Institution', 'Location', 'Founded', 'Affiliation', 'Enrollment', 'Team Nickname', 'Primary conference']
Types: ['text', 'text', 'real', 'text', 'real', 'text', 'text']
Sample row: ['University of Houston', 'Houston, Texas', 1927.0, 'Public', 40747.0, 'Cougars', 'American ( Division I )']
SQL:

assistant: SELECT "Enrollment" FROM "Table" WHERE "Team Nickname" = 'Comets';