What is the average week rank with 1.2 ratings, less than 1.94 million viewers, and a night rank less than 11?
CREATE TABLE "tv_ratings" (
  "order" text,
  "episode" text,
  "rating" real,
  "share" real,
  "rating_share_18_49" text,
  "viewers_millions" real,
  "rank_night" real,
  "rank_timeslot" real,
  "rank_week" real
);
SELECT AVG("rank_week") FROM "tv_ratings" WHERE "rating"=1.2 AND "viewers_millions"<1.94 AND "rank_night"<11;