Table: john_hearne
Columns: name
team_s
matches
balls_bowled
wickets_taken
average

Question: What are the names of all the players with an average of 15.89?
SQL: SELECT "name" FROM john_hearne WHERE "average" = '15.89'

Question: What's the maximum wickets taken by players named Bill Lockwood?
SQL: SELECT MAX("wickets_taken") FROM john_hearne WHERE "name" = 'Bill Lockwood'

Question: What are all the teams with an average of 15.89?
SQL: SELECT "team_s" FROM john_hearne WHERE "average" = '15.89'

Question: Who are all the players who've bowled more than 4969 balls?
SQL: SELECT "name" FROM john_hearne WHERE "balls_bowled" = 4969

Question: What are the averages for games with 212 wickets taken?
SQL: SELECT "average" FROM john_hearne WHERE "wickets_taken" = 212