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

Question: How many numbers were recorde under 50s when there was 2 matches?
SQL: SELECT COUNT("50s") FROM ashes_1948_player_stats WHERE "matches" = 2

Question: What was the score when Donald Bradman in 9 innings?
SQL: SELECT "highest_score" FROM ashes_1948_player_stats WHERE "innings" = 9 AND "player" = 'Donald Bradman'

Question: What is the highest number of matches?
SQL: SELECT MAX("matches") FROM ashes_1948_player_stats

Question: How many numbers were recorded under matches with Arthur Morris?
SQL: SELECT COUNT("matches") FROM ashes_1948_player_stats WHERE "player" = 'Arthur Morris'

Question: How many teams were there with a high score of 143?
SQL: SELECT COUNT("team") FROM ashes_1948_player_stats WHERE "highest_score" = '143'