Table: rcb_stats
Columns: year
matches
wins
losses
no_result
success_rate
away_wins
away_losses

Question: What is the highest No Result when there were less than 7 losses, and more than 3 away wins, with a success Rate of 50.00%?
SQL: SELECT MAX("no_result") FROM rcb_stats WHERE "losses" > 7 AND "away_wins" > 3 AND "success_rate" = '50.00%'

Question: What is the sum of Away Losses with a No Result of more than 0, losses of more than 6, and matches of more than 91?
SQL: SELECT SUM("away_losses") FROM rcb_stats WHERE "no_result" > 0 AND "losses" > 6 AND "matches" > 91

Question: What is the sum of Wins with a result of 0, and the away wins of 1, and the losses are less than 5?
SQL: SELECT SUM("wins") FROM rcb_stats WHERE "no_result" = 0 AND "away_wins" = 1 AND "losses" < 5