Table: western_eagles_stats
Columns: league
number_of_seasons
total_games
draw
loss

Question: What is the average draw for 186 games?
SQL: SELECT AVG("draw") FROM western_eagles_stats WHERE "total_games" = 186

Question: What is the number of games for less than 2 seasons and more than 7 draws?
SQL: SELECT SUM("total_games") FROM western_eagles_stats WHERE "number_of_seasons" < 2 AND "draw" > 7

Question: What is the total number of losses for less than 48 games, and less than 7 draws?
SQL: SELECT COUNT("loss") FROM western_eagles_stats WHERE "total_games" < 48 AND "draw" < 7

Question: What is the total number of games with more than 18 loses, a Total League, and more than 317 draws?
SQL: SELECT COUNT("total_games") FROM western_eagles_stats WHERE "loss" > 18 AND "league" = 'total' AND "draw" > 317