What kind of Week 9 has a Week 1 of no nominations, and a Week 6 of not eligible, and a Week 2 of not eligible, and a Week 10 FINAL of evicted (day 57)?
CREATE TABLE "nominations" (
  "week_1" text,
  "week_2" text,
  "week_3" text,
  "week_4" text,
  "week_5" text,
  "week_6" text,
  "week_7" text,
  "week_8" text,
  "week_9" text,
  "week_10_final" text
);
SELECT "week_9" FROM "nominations" WHERE "week_1"='no nominations' AND "week_6"='not eligible' AND "week_2"='not eligible' AND "week_10_final"='evicted (day 57)';