Table schema:
CREATE TABLE table_2655016_10 (season__number INTEGER, nick_prod__number VARCHAR)

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