Which Years at club have Games smaller than 7, and Goals larger than 2, and a Player of john frazer?
CREATE TABLE "1970s" (
  "debut_year" real,
  "player" text,
  "games" real,
  "goals" real,
  "years_at_club" text
);
SELECT "years_at_club" FROM "1970s" WHERE "games"<7 AND "goals">2 AND "player"='john frazer';