Table: fitzroy_players_3
Columns: debut_year
player
games
goals
years_at_club

Question: How many Games have Years at club of 1971–1974, and a Debut year larger than 1971?
SQL: SELECT SUM("games") FROM fitzroy_players_3 WHERE "years_at_club" = '1971–1974' AND "debut_year" > 1971

Question: Which Games have Years at club of 1974–1975, and Goals of 4?
SQL: SELECT AVG("games") FROM fitzroy_players_3 WHERE "years_at_club" = '1974–1975' AND "goals" = 4

Question: Which Years at club have Games smaller than 7, and Goals larger than 2, and a Player of john frazer?
SQL: SELECT "years_at_club" FROM fitzroy_players_3 WHERE "games" < 7 AND "goals" > 2 AND "player" = 'john frazer'

Question: Which Games have Years at club of 1977, and Goals of 17, and a Debut year smaller than 1977?
SQL: SELECT AVG("games") FROM fitzroy_players_3 WHERE "years_at_club" = '1977' AND "goals" = 17 AND "debut_year" < 1977

Question: Which Goals have Games smaller than 41, and a Player of mark amos?
SQL: SELECT MIN("goals") FROM fitzroy_players_3 WHERE "games" < 41 AND "player" = 'mark amos'