CREATE TABLE table_10342 ("No. in series" FLOAT, "No. in season" FLOAT, "Title" CLOB, "Director" CLOB, "Writer ( s ) " CLOB, "Original air date" CLOB, "Production code" CLOB)

What production code does episode 174 of Melrose place have?
SELECT "Production code" FROM table_10342 WHERE "No. in series" = '174'
SELECT "Production code" FROM "table_10342" WHERE "No. in series" = '174'