Table: batsman_stats
Columns: matches
innings
not_out
runs
high_score
average

Question: How many runs were there when the high score was 55 and there were more than 12 innings?
SQL: SELECT SUM("runs") FROM batsman_stats WHERE "high_score" = 55 AND "innings" > 12

Question: How many runs were there when there was 1 match and les than 86 average?
SQL: SELECT SUM("runs") FROM batsman_stats WHERE "matches" = 1 AND "average" < 86