user: Question: Which Years at club have Games smaller than 7, and Goals larger than 2, and a Player of John Frazer?
Columns: ['Debut year', 'Player', 'Games', 'Goals', 'Years at club']
Types: ['real', 'text', 'real', 'real', 'text']
Sample row: [1970.0, 'Alan Thompson', 138.0, 59.0, '1970–1979']
SQL:

assistant: SELECT "Years at club" FROM "Table" WHERE "Games" < 7.0 AND "Goals" > 2.0 AND "Player" = 'John Frazer';