CREATE TABLE table_name_97 (years_competed VARCHAR2, nickname VARCHAR2)

Tell me the years competed for panthers
SELECT years_competed FROM table_name_97 WHERE nickname = "panthers"
SELECT "years_competed" FROM "table_name_97" WHERE "nickname" = "panthers"