SCHEMA:
CREATE TABLE table_name_92 (production_code VARCHAR, no_in_series VARCHAR)
USER:
What production code does episode 174 of Melrose place have?

QUERY:
SELECT production_code FROM table_name_92 WHERE no_in_series = 174