Table schema:
CREATE TABLE table_name_92 (production_code VARCHAR, no_in_series VARCHAR)

Question: What production code does episode 174 of Melrose place have?
SQL: SELECT production_code FROM table_name_92 WHERE no_in_series = 174