Who was the opponent when the H/A was H and the scorer was Ferguson?
CREATE TABLE "pre_season_and_friendlies" (
  "date" text,
  "opponents" text,
  "h_a" text,
  "result_f_a" text,
  "scorers" text
);
SELECT "opponents" FROM "pre_season_and_friendlies" WHERE "h_a"='h' AND "scorers"='ferguson';