Who was the opponent for game number less than 47 and a record of 24-13-4?
CREATE TABLE "schedule_and_results" (
  "game" real,
  "january" real,
  "opponent" text,
  "score" text,
  "record" text
);
SELECT "opponent" FROM "schedule_and_results" WHERE "game"<47 AND "record"='24-13-4';