Table: ice_cats_games_94
Columns: season
games
lost
tied
points
goals_for
goals_against
standing

Question: How many games were lost by more than 27 but not more 78 with goals less than 300?
SQL: SELECT AVG("games") FROM ice_cats_games_94 WHERE "lost" > 27 AND "points" < 78 AND "goals_against" < 300

Question: How many games had a tied less 15 with goals against being fewer than 186?
SQL: SELECT COUNT("games") FROM ice_cats_games_94 WHERE "tied" < 15 AND "goals_against" < 186

Question: What's the least amount of goals for a game that had a tied bigger than 15?
SQL: SELECT MIN("goals_for") FROM ice_cats_games_94 WHERE "tied" > 15