user: ### NOW ANSWER:
Question: What production code does episode 174 of Melrose place have?
Columns: ['No. in series', 'No. in season', 'Title', 'Director', 'Writer(s)', 'Original air date', 'Production code']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [165.0, 1.0, '"A Brand New Day"', 'Frank South', 'Frank South', 'September8,1997', '2397158']
SQL:

assistant: SELECT "Production code" FROM "Table" WHERE "No. in series" = 174.0;