Table: ntfa_div1_stats
Columns: ntfa_div_1
wins
byes
losses
draws
against

Question: What is the total number of byes that are associated with 1 draw, 5 wins, and fewer than 12 losses?
SQL: SELECT SUM("byes") FROM ntfa_div1_stats WHERE "draws" = 1 AND "wins" = 5 AND "losses" < 12

Question: What is the total number of byes associated with fewer than 8 wins and fewer than 1 draw?
SQL: SELECT COUNT("byes") FROM ntfa_div1_stats WHERE "draws" < 1 AND "wins" < 8

Question: What is the NTFA Div 1 team that has 15 wins and less than 1 draw?
SQL: SELECT "ntfa_div_1" FROM ntfa_div1_stats WHERE "draws" < 1 AND "wins" = 15

Question: What is the average number of losses for teams with 0 draws and 0 byes?
SQL: SELECT AVG("losses") FROM ntfa_div1_stats WHERE "draws" = 0 AND "byes" < 0

Question: What is the most number of losses for teams with 5 wins and an against value under 1607?
SQL: SELECT MAX("losses") FROM ntfa_div1_stats WHERE "wins" = 5 AND "against" < 1607