Table: afl_records_2
Columns: rank
goals
player
club
season

Question: What player scored 143 goals?
SQL: SELECT "player" FROM afl_records_2 WHERE "goals" = '143'

Question: In what season was there a club of South Melbourne?
SQL: SELECT "season" FROM afl_records_2 WHERE "club" = 'south melbourne'

Question: What club scored 143 goals?
SQL: SELECT "club" FROM afl_records_2 WHERE "goals" = '143'

Question: In what season did Bob Pratt play?
SQL: SELECT "season" FROM afl_records_2 WHERE "player" = 'bob pratt'

Question: How many goals did the club from Hawthorn score in the 1971 season?
SQL: SELECT "goals" FROM afl_records_2 WHERE "club" = 'hawthorn' AND "season" = '1971'