What tier had a runner-up of Lisa Raymond and a semifinalist of Sandrine Testud Mary Pierce?
CREATE TABLE "july" (
  "week_of" text,
  "tier" text,
  "winner" text,
  "runner_up" text,
  "semi_finalists" text
);
SELECT "tier" FROM "july" WHERE "semi_finalists"='sandrine testud mary pierce' AND "runner_up"='lisa raymond';