Table: top_scorers_2
Columns: rank
name
years
matches
goals

Question: What is the mean number of goals when the rank's less than 8 and there are 261 matches?
SQL: SELECT AVG("goals") FROM top_scorers_2 WHERE "rank" < 8 AND "matches" = 261

Question: Which years had a rank of more than 6 and involved Oleksandr Kosyrin?
SQL: SELECT "years" FROM top_scorers_2 WHERE "rank" > 6 AND "name" = 'oleksandr kosyrin'