CREATE TABLE table_27982 ("No. in series" FLOAT, "Title" CLOB, "Directed by" CLOB, "Written by" CLOB, "Original air date" CLOB, "Production code" CLOB, "U.S. viewers  ( million ) " CLOB)

Who directed episode number 18 in the series?
SELECT "Directed by" FROM table_27982 WHERE "No. in series" = '18'
SELECT "Directed by" FROM "table_27982" WHERE "No. in series" = '18'