Table: rugby_world_cup_stats
Columns: played
drawn
lost
against
won

Question: What Played has a Lost smaller than 3, and a Drawn smaller than 0?
SQL: SELECT AVG("played") FROM rugby_world_cup_stats WHERE "lost" < 3 AND "drawn" < 0

Question: What is the largest % Won with a Lost smaller than 0?
SQL: SELECT MAX("won") FROM rugby_world_cup_stats WHERE "lost" < 0

Question: What is the total of Against with % Won larger than 100?
SQL: SELECT SUM("against") FROM rugby_world_cup_stats WHERE "won" > 100

Question: What is the smallest Against with Lost larger than 0, % Won larger than 50, and Played smaller than 5?
SQL: SELECT MIN("against") FROM rugby_world_cup_stats WHERE "lost" > 0 AND "won" > 50 AND "played" < 5

Question: What is the Lost with Against smaller than 25, and Played smaller than 1?
SQL: SELECT AVG("lost") FROM rugby_world_cup_stats WHERE "against" < 25 AND "played" < 1