CREATE TABLE table_2780 ("No." FLOAT, "#" FLOAT, "Title" CLOB, "Directed by" CLOB, "Written by" CLOB, "U.S. viewers  ( million ) " CLOB, "Rank  ( week ) " FLOAT, "Original air date" CLOB)

What was the week ranking of the episode written by Thomas L. Moran and directed by Andrew Bernstein?
SELECT "Rank (week)" FROM table_2780 WHERE "Written by" = 'Thomas L. Moran' AND "Directed by" = 'Andrew Bernstein'
SELECT "Rank (week)" FROM "table_2780" WHERE "Directed by" = 'Andrew Bernstein' AND "Written by" = 'Thomas L. Moran'