Table: pioneers_hockey_stats
Columns: coach
years
wins
losses
ties

Question: What years did the person coach who had more than 31 ties?
SQL: SELECT "years" FROM pioneers_hockey_stats WHERE "ties" > 31

Question: What is the average number of wins for the person who coached from 1951 to 1956 and had less than 174 losses and less than 6 ties?
SQL: SELECT AVG("wins") FROM pioneers_hockey_stats WHERE "losses" < 174 AND "years" = '1951 to 1956' AND "ties" < 6

Question: Who was the coach who had 215 losses?
SQL: SELECT "coach" FROM pioneers_hockey_stats WHERE "losses" = 215

Question: What years did the person coach who had more than 1 tie, mess than 311 wins and 174 losses?
SQL: SELECT "years" FROM pioneers_hockey_stats WHERE "ties" > 1 AND "wins" < 311 AND "losses" = 174

Question: What years did the person coach who had less than 82 wins and more than 24 losses?
SQL: SELECT "years" FROM pioneers_hockey_stats WHERE "wins" < 82 AND "losses" > 24