Table: top_football_scorers_12
Columns: rank
name
years
matches
goals

Question: Which Rank has a Goals smaller than 76, and a Matches larger than 270?
SQL: SELECT SUM("rank") FROM top_football_scorers_12 WHERE "goals" < 76 AND "matches" > 270

Question: Which Matches have a Rank smaller than 5, a Years of 1995–2003, and a Goals smaller than 104?
SQL: SELECT AVG("matches") FROM top_football_scorers_12 WHERE "rank" < 5 AND "years" = '1995–2003' AND "goals" < 104

Question: Which Goals have a Name of lee dong-gook?
SQL: SELECT MAX("goals") FROM top_football_scorers_12 WHERE "name" = 'lee dong-gook'

Question: Which Rank has a Years of 1998–present?
SQL: SELECT AVG("rank") FROM top_football_scorers_12 WHERE "years" = '1998–present'

Question: Which Matches have a Rank of 2?
SQL: SELECT COUNT("matches") FROM top_football_scorers_12 WHERE "rank" = 2