Table: top_football_scorers_4
Columns: rank
name
years
matches
goals

Question: What is the average number of goals for players ranked above 9 and playing more than 205 matches?
SQL: SELECT AVG("goals") FROM top_football_scorers_4 WHERE "matches" = 205 AND "rank" > 9

Question: What is the average rank for players with under 205 matches and under 100 goals?
SQL: SELECT AVG("rank") FROM top_football_scorers_4 WHERE "matches" < 205 AND "goals" < 100

Question: What years played did the player with a rank under 10, more than 271 matches, and 152 goals have?
SQL: SELECT "years" FROM top_football_scorers_4 WHERE "rank" < 10 AND "matches" > 271 AND "goals" = 152