What is the weekly rank with an air date is november 12, 2007?
CREATE TABLE "u_s_ratings" (
  "num" real,
  "episode" text,
  "air_date" text,
  "rating" text,
  "share" real,
  "18_49_rating_share" text,
  "viewers_m" text,
  "weekly_rank" real
);
SELECT "weekly_rank" FROM "u_s_ratings" WHERE "air_date"='November 12, 2007';