Was the semi-final round held at home or away?
CREATE TABLE "manchester_and_district_challenge_cup" (
  "date" text,
  "round" text,
  "opponents" text,
  "h_a" text,
  "result_f_a" text
);
SELECT "h_a" FROM "manchester_and_district_challenge_cup" WHERE "round"='semi-final';