Table: spartak_dynamo_derby
Columns: competition
played
spartak
draw
dynamo

Question: what is the average dynamo when draw is more than 0, played is less than 15 and spartak is more than 1?
SQL: SELECT AVG("dynamo") FROM spartak_dynamo_derby WHERE "draw" > 0 AND "played" < 15 AND "spartak" > 1

Question: what is the highest spartak when played is less than 15 and dynamo is less than 3?
SQL: SELECT MAX("spartak") FROM spartak_dynamo_derby WHERE "played" < 15 AND "dynamo" < 3

Question: what is the most draw when the competition is soviet league and dynamo is more than 34?
SQL: SELECT MAX("draw") FROM spartak_dynamo_derby WHERE "competition" = 'soviet league' AND "dynamo" > 34

Question: what is the sum of spartak when played is 102 and draw is less than 19?
SQL: SELECT SUM("spartak") FROM spartak_dynamo_derby WHERE "played" = 102 AND "draw" < 19

Question: what is the least dynamo when spartak is more than 9, competition is totals and draw is more than 24?
SQL: SELECT MIN("dynamo") FROM spartak_dynamo_derby WHERE "spartak" > 9 AND "competition" = 'totals' AND "draw" > 24