In how many different years was the team nicknamed Comets founded?
CREATE TABLE table_28243691_2 (founded VARCHAR, team_nickname VARCHAR)
SELECT COUNT(founded) FROM table_28243691_2 WHERE team_nickname = "Comets"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28243691_2 (founded VARCHAR, team_nickname VARCHAR) Question: In how many different years was the team nicknamed Comets founded? [/INST] SELECT COUNT(founded) FROM table_28243691_2 WHERE team_nickname = "Comets" </s>