Table: team_stats_5
Columns: year
total
wins
losses
no_result
win

Question: How many losses had a total of 17 and more than 10 wins?
SQL: SELECT COUNT("losses") FROM team_stats_5 WHERE "total" = 17 AND "wins" > 10

Question: What is the win percentage when there's more than 16 totals and less than 7 losses?
SQL: SELECT "win" FROM team_stats_5 WHERE "total" > 16 AND "losses" < 7

Question: What is the smallest no result when the year was 2012 and there were more than 10 wins?
SQL: SELECT MIN("no_result") FROM team_stats_5 WHERE "year" = '2012' AND "wins" > 10