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

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'