Table: russian_football_players
Columns: rank
player
goals
apps
avg_game

Question: What is the average number of goals of the player with 234 apps and a rank above 8?
SQL: SELECT AVG("goals") FROM russian_football_players WHERE "apps" = 234 AND "rank" < 8

Question: What is the average avg/game of the player with 97 goals and a rank above 7?
SQL: SELECT AVG("avg_game") FROM russian_football_players WHERE "goals" = 97 AND "rank" < 7