What kind of Week 4  has a Week 9 of all housemates?
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_4" FROM "nominations" WHERE "week_9"='all housemates';