What was the latest season with a nick production number of 942?
CREATE TABLE table_2655016_10 (season__number INTEGER, nick_prod__number VARCHAR)
SELECT MAX(season__number) FROM table_2655016_10 WHERE nick_prod__number = 942
<s>[INST] Write mssql query to answer the following question given the database schema. 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? [/INST] SELECT MAX(season__number) FROM table_2655016_10 WHERE nick_prod__number = 942 </s>