Which Record has a Year larger than 1974, and a Finish of 3rd?
CREATE TABLE "year_by_year_record" (
  "year" real,
  "record" text,
  "finish" text,
  "manager" text,
  "playoffs" text
);
SELECT "record" FROM "year_by_year_record" WHERE "year">1974 AND "finish"='3rd';