Which Match played in a Location of San Francisco has a Competition of Semifinal?
CREATE TABLE "matches_and_goals_scored_at_world_cup_an" (
  "match" text,
  "date" text,
  "location" text,
  "lineup" text,
  "result" text,
  "competition" text
);
SELECT "match" FROM "matches_and_goals_scored_at_world_cup_an" WHERE "competition"='semifinal' AND "location"='san francisco';