Table: cricket_stats_4
Columns: year
played
wins
losses
no_result
win

Question: How many Played has a % Win of 50.00%, and Losses of 1, and Wins smaller than 1?
SQL: SELECT COUNT("played") FROM cricket_stats_4 WHERE "win" = '50.00%' AND "losses" = 1 AND "wins" < 1

Question: WHAT kind of No Result has Wins smaller than 2, and Losses larger than 1?
SQL: SELECT "no_result" FROM cricket_stats_4 WHERE "wins" < 2 AND "losses" > 1

Question: How many Played that has Losses of 6, and Wins larger than 33?
SQL: SELECT AVG("played") FROM cricket_stats_4 WHERE "losses" = 6 AND "wins" > 33

Question: What  kind of No Result  has a % Win of 100.00% and a Played larger than 4 in 2012?
SQL: SELECT MIN("no_result") FROM cricket_stats_4 WHERE "win" = '100.00%' AND "played" > 4 AND "year" = '2012'