Who is in week 4 if week 5 is [month ended] and week 2 is April Ireland?
CREATE TABLE "2007" (
  "week_1" text,
  "week_2" text,
  "week_3" text,
  "week_4" text,
  "week_5" text
);
SELECT "week_4" FROM "2007" WHERE "week_5"='[month ended]' AND "week_2"='april ireland';