Table: nz_test_crickets
Columns: matches
innings
not_outs
runs
average

Question: What is the lowest Not Outs with an average lower than 31.25, fewer than 13 matches, and fewer than 327 runs?
SQL: SELECT MIN("not_outs") FROM nz_test_crickets WHERE "average" < 31.25 AND "matches" < 13 AND "runs" < 327

Question: What is the total number of runs when the average was less than 31.25 and there were fewer than 24 innings?
SQL: SELECT COUNT("runs") FROM nz_test_crickets WHERE "average" > 31.25 AND "innings" < 24

Question: What is the lowest number of Not Outs when there were more than 25 innings?
SQL: SELECT MIN("not_outs") FROM nz_test_crickets WHERE "innings" > 25

Question: What is the number of Not Outs when there were more than 327 runs and 24 innings, and an average of 29.54
SQL: SELECT "not_outs" FROM nz_test_crickets WHERE "runs" > 327 AND "innings" > 24 AND "average" = 29.54

Question: What is the total number of runs where the average is less than 27.22?
SQL: SELECT COUNT("runs") FROM nz_test_crickets WHERE "average" < 27.22