Table: baseball_world_cup_2007
Columns: rank
team
wins
losses
runs_allowed
run_ratio

Question: How many losses did the team with 0 wins and more than 72 runs allowed have?
SQL: SELECT SUM("losses") FROM baseball_world_cup_2007 WHERE "wins" = 0 AND "runs_allowed" > 72

Question: What is the lowest amount of losses the United States, ranked higher than 3 with more than 6 wins, have?
SQL: SELECT MIN("losses") FROM baseball_world_cup_2007 WHERE "rank" < 3 AND "team" = 'united states' AND "wins" > 6

Question: How many runs allowed did the team ranked 2 with more than 2 losses have?
SQL: SELECT AVG("runs_allowed") FROM baseball_world_cup_2007 WHERE "rank" = 2 AND "losses" > 2

Question: How many total wins did the team ranked lower than 1 with a run ratio less than 5.85 and more than 4 losses have?
SQL: SELECT COUNT("wins") FROM baseball_world_cup_2007 WHERE "rank" > 1 AND "run_ratio" < 5.85 AND "losses" > 4

Question: What is the highest run ratio Japan, which has less than 58 runs and 5 wins, have?
SQL: SELECT MAX("run_ratio") FROM baseball_world_cup_2007 WHERE "runs_allowed" < 58 AND "wins" = 5 AND "team" = 'japan'

Question: What is the average number of losses the team with less than 25 runs allowed and 5 wins have?
SQL: SELECT AVG("losses") FROM baseball_world_cup_2007 WHERE "runs_allowed" < 25 AND "wins" = 5