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

Question: Which player has less than 2 in the 100s category, more than 4 matches, and an average greater than 42.75?
SQL: SELECT "player" FROM ashes_1948_player_stats_2 WHERE "100s" < 2 AND "average" > 42.75 AND "matches" > 4

Question: How many matches have a 100s category less than 0?
SQL: SELECT COUNT("matches") FROM ashes_1948_player_stats_2 WHERE "100s" < 0

Question: What is the average number of innings with more than 3 in the 100s category?
SQL: SELECT AVG("innings") FROM ashes_1948_player_stats_2 WHERE "100s" > 3

Question: What is the largest number of innings with less than 342 runs and more than 4 matches?
SQL: SELECT MAX("innings") FROM ashes_1948_player_stats_2 WHERE "runs" < 342 AND "matches" > 4

Question: What is the average value in the 100s category when the high score is 196?
SQL: SELECT AVG("100s") FROM ashes_1948_player_stats_2 WHERE "highest_score" = '196'