CREATE TABLE table_name_25 (super_g VARCHAR, career VARCHAR)

What Super G has a Career of 1980 1996?
SELECT super_g FROM table_name_25 WHERE career = "1980–1996"
SELECT "super_g" FROM "table_name_25" WHERE "1980–1996" = "career"