CREATE TABLE table_name_92 (production_code VARCHAR(255), no_in_series VARCHAR(255))
What production code does episode 174 of Melrose place have?
    
SQL: SELECT production_code FROM table_name_92 WHERE no_in_series = 174