Table: univ_houston
Columns: institution
location
founded
affiliation
enrollment
team_nickname
primary_conference

Question: In how many different years was the team nicknamed Comets founded?
SQL: SELECT COUNT("founded") FROM univ_houston WHERE "team_nickname" = 'Comets'

Question: What's the nickname of the team with enrollment of 40747?
SQL: SELECT "team_nickname" FROM univ_houston WHERE "enrollment" = 40747

Question: What school is located in Huntsville, Texas?
SQL: SELECT "institution" FROM univ_houston WHERE "location" = 'Huntsville, Texas'

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