CREATE TABLE table_2655016_10 (season__number INT, nick_prod__number VARCHAR)

What was the latest season with a nick production number of 942?
SELECT MAX(season__number) FROM table_2655016_10 WHERE nick_prod__number = 942
SELECT MAX("season__number") FROM "table_2655016_10" WHERE "nick_prod__number" = 942