Table: player_stats_70
Columns: player
club
games
goals
assists
points

Question: How many games have 5 goals and less than 8 assists?
SQL: SELECT COUNT("games") FROM player_stats_70 WHERE "goals" = 5 AND "assists" < 8

Question: What is the highest number of goals Eisbären Berlin had along with 13 points and 10 assists?
SQL: SELECT MAX("goals") FROM player_stats_70 WHERE "points" = 13 AND "assists" = 10 AND "club" = 'eisbären berlin'

Question: What is Ivan Ciernik's average points with less than 11 goals?
SQL: SELECT AVG("points") FROM player_stats_70 WHERE "player" = 'ivan ciernik' AND "goals" < 11