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%?
CREATE TABLE "overall_results_in_the_ipl" (
  "year" text,
  "matches" real,
  "wins" real,
  "losses" real,
  "no_result" real,
  "success_rate" text,
  "away_wins" real,
  "away_losses" real
);
SELECT MAX("no_result") FROM "overall_results_in_the_ipl" WHERE "losses">7 AND "away_wins">3 AND "success_rate"='50.00%';