Table: hfnl_stats_2
Columns: club
wins
losses
draws
against

Question: What is the average number of losses when there are more than 4 wins, and the against matches is more than 1728?
SQL: SELECT AVG("losses") FROM hfnl_stats_2 WHERE "wins" < 4 AND "against" > 1728

Question: What is the total number of draws when there is 1 Win, and less than 1728 against matches?
SQL: SELECT COUNT("draws") FROM hfnl_stats_2 WHERE "wins" = 1 AND "against" < 1728

Question: What is the highest number of wins when there are less than 2 losses?
SQL: SELECT MAX("wins") FROM hfnl_stats_2 WHERE "losses" < 2

Question: What is the highest number of losses for the Cobden club when there is less than 1 win?
SQL: SELECT MAX("losses") FROM hfnl_stats_2 WHERE "club" = 'cobden' AND "wins" < 1

Question: What is the average number of wins for the Terang Club, when there are less than 0 draws?
SQL: SELECT AVG("wins") FROM hfnl_stats_2 WHERE "club" = 'terang' AND "draws" < 0