Table: kxip_stats
Columns: year
matches
wins
losses
no_result
win

Question: What is the number of losses for the game with a win % of 71.43%, and No Result is more than 0?
SQL: SELECT SUM("losses") FROM kxip_stats WHERE "win" = '71.43%' AND "no_result" > 0

Question: What is the total number of wins in 2010, when there were more than 14 matches?
SQL: SELECT COUNT("wins") FROM kxip_stats WHERE "year" = '2010' AND "matches" > 14

Question: What is the number of wins when there are 14 matches, and the No Result was less than 0?
SQL: SELECT AVG("wins") FROM kxip_stats WHERE "matches" = 14 AND "no_result" < 0

Question: What is the number of losses when there were 14 matches, and the No Result was larger than 0?
SQL: SELECT SUM("losses") FROM kxip_stats WHERE "matches" = 14 AND "no_result" > 0

Question: What is the number of matches when the wins are less than 8, and losses of 7, in 2011?
SQL: SELECT SUM("matches") FROM kxip_stats WHERE "wins" < 8 AND "losses" = 7 AND "year" = '2011'

Question: What year was the Win percentage 50.00%, with more than 14 matches, and wins more than 8?
SQL: SELECT "year" FROM kxip_stats WHERE "win" = '50.00%' AND "matches" > 14 AND "wins" > 8