Table: goal_scorers
Columns: rank
name
years
matches
goals

Question: What was the total matches that ranked above 10?
SQL: SELECT SUM("matches") FROM goal_scorers WHERE "rank" > 10

Question: What was the total amount of matches for Alan Shearer?
SQL: SELECT COUNT("matches") FROM goal_scorers WHERE "name" = 'alan shearer'

Question: What is the average goals for Jimmy Greaves, and matches more than 516?
SQL: SELECT AVG("goals") FROM goal_scorers WHERE "name" = 'jimmy greaves' AND "matches" > 516

Question: What was the total number of matches for Nat Lofthouse, ranking higher than 7?
SQL: SELECT COUNT("matches") FROM goal_scorers WHERE "name" = 'nat lofthouse' AND "rank" > 7

Question: What is the highest rank for Nat Lofthouse, and goals more than 255?
SQL: SELECT MAX("rank") FROM goal_scorers WHERE "name" = 'nat lofthouse' AND "goals" > 255