Table: twenty20_stats
Columns: player
team
matches
inns
runs
balls
s_rate
100s
average

Question: How many Matches have an S/Rate smaller than 133.72, and a Team of yorkshire carnegie?
SQL: SELECT COUNT("matches") FROM twenty20_stats WHERE "s_rate" < 133.72 AND "team" = 'yorkshire carnegie'

Question: Which Team has Balls smaller than 258, and Inns of 10, and Matches smaller than 12?
SQL: SELECT "team" FROM twenty20_stats WHERE "balls" < 258 AND "inns" = 10 AND "matches" < 12

Question: How many Matches have Balls smaller than 224, and an Average larger than 38.25, and an S/Rate larger than 139.09?
SQL: SELECT SUM("matches") FROM twenty20_stats WHERE "balls" < 224 AND "average" > 38.25 AND "s_rate" > 139.09

Question: How many Matches have an Average larger than 26.53, and an S/Rate of 165.4, and a 100s smaller than 1?
SQL: SELECT COUNT("matches") FROM twenty20_stats WHERE "average" > 26.53 AND "s_rate" = 165.4 AND "100s" < 1