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

Question: How many goals for were scored for the team(s) that won fewer than 4 games and lost more than 6?
SQL: SELECT SUM("goals_for") FROM t_1900_cahl_season WHERE "wins" < 4 AND "losses" > 6

Question: What is the average losses for the team(s) that played more than 8 games?
SQL: SELECT AVG("losses") FROM t_1900_cahl_season WHERE "games_played" > 8