Table schema:
CREATE TABLE table_29102100_1 (season__number INTEGER, prod_code VARCHAR)

Question: What number episode in the season had a production code of 334?
SQL: SELECT MAX(season__number) FROM table_29102100_1 WHERE prod_code = 334