Table: player_stats_2010
Columns: player
matches
innings
runs
average
highest_score
100s
50s

Question: What is the average when the highest score is 151?
SQL: SELECT "average" FROM player_stats_2010 WHERE "highest_score" = '151'

Question: Who is the player when the highest score is 84?
SQL: SELECT "player" FROM player_stats_2010 WHERE "highest_score" = '84'

Question: How many runs are there when the highest score is 228*?
SQL: SELECT MIN("runs") FROM player_stats_2010 WHERE "highest_score" = '228*'

Question: What is the average when the 100s is listed as 7?
SQL: SELECT "average" FROM player_stats_2010 WHERE "100s" = 7

Question: What is the innings when the highest score is 72?
SQL: SELECT MAX("innings") FROM player_stats_2010 WHERE "highest_score" = '72'