CREATE TABLE table_name_26 (nickname VARCHAR2, no_of_premierships VARCHAR2, years_in_competition VARCHAR2)

What was the Nickname that had a No. 0, and Years in Competition of 1982-2003?
SELECT nickname FROM table_name_26 WHERE no_of_premierships = 0 AND years_in_competition = "1982-2003"
SELECT "nickname" FROM "table_name_26" WHERE "1982-2003" = "years_in_competition" AND "no_of_premierships" = 0