Table: top_football_scorers_7
Columns: rank
name
years
matches
goals

Question: How many ranks had 367 matches and more than 216 goals?
SQL: SELECT SUM("rank") FROM top_football_scorers_7 WHERE "matches" = 367 AND "goals" > 216

Question: What is the mean rank number when goals are 230 and there are more than 535?
SQL: SELECT AVG("rank") FROM top_football_scorers_7 WHERE "goals" = 230 AND "matches" > 535