Table: t_1903_cahl_season
Columns: team
games_played
wins
losses
ties
goals_for
goals_against

Question: How many goals for occurred when the goals against was less than 56 and games played was larger than 7 with less than 6 wins?
SQL: SELECT COUNT("goals_for") FROM t_1903_cahl_season WHERE "goals_against" < 56 AND "games_played" > 7 AND "wins" < 6

Question: What is the smallest number of wins with 7 games played and goals against less than 46 when goals for is more than 34?
SQL: SELECT MIN("wins") FROM t_1903_cahl_season WHERE "games_played" = 7 AND "goals_against" < 46 AND "goals_for" > 34

Question: What is the average number of ties when goals against is less than 56 for Ottawa Hockey Club and the goals for is more than 47?
SQL: SELECT AVG("ties") FROM t_1903_cahl_season WHERE "goals_against" < 56 AND "team" = 'ottawa hockey club' AND "goals_for" > 47

Question: How many losses occurred with less than 8 games played and less than 3 wins?
SQL: SELECT COUNT("losses") FROM t_1903_cahl_season WHERE "games_played" < 8 AND "wins" < 3

Question: How many goals against were scored when the goals for is less than 48 with 0 ties?
SQL: SELECT COUNT("goals_against") FROM t_1903_cahl_season WHERE "goals_for" < 48 AND "ties" < 0