question: In how many different years was the team nicknamed Comets founded?
answer: SELECT COUNT(founded) FROM table_28243691_2 WHERE team_nickname = "Comets"
context: CREATE TABLE table_28243691_2 (founded VARCHAR, team_nickname VARCHAR)