Table: glos_cc_2006_players
Columns: player
matches
inns
runs
high_score
average
catches
stump

Question: What is the high score for the player with 0 stumps, 4 catches, more than 14 inns and an average smaller than 56.1?
SQL: SELECT SUM("high_score") FROM glos_cc_2006_players WHERE "stump" = 0 AND "catches" = 4 AND "average" < 56.1 AND "inns" > 14

Question: What is the total number of runs for the player with fewer than 9 Inns?
SQL: SELECT COUNT("runs") FROM glos_cc_2006_players WHERE "inns" < 9

Question: What is the smallest average for the player with 13 matches and fewer than 7 catches?
SQL: SELECT MIN("average") FROM glos_cc_2006_players WHERE "matches" = 13 AND "catches" < 7