CREATE TABLE table_74106 ("No. in series" FLOAT, "No. in season" FLOAT, "Title" CLOB, "Directed by" CLOB, "Written by" CLOB, "Original air date" CLOB, "U.S. viewers  ( millions ) " CLOB)

What number episode in the season was directed by Paul Adelstein?
SELECT MAX("No. in season") FROM table_74106 WHERE "Directed by" = 'Paul Adelstein'
SELECT MAX("No. in season") FROM "table_74106" WHERE "Directed by" = 'Paul Adelstein'