Table: player_stats_42
Columns: ranking
nationality
name
years
goals

Question: What is the number of ranking when the nationalits is England with more than 53 goals?
SQL: SELECT SUM("ranking") FROM player_stats_42 WHERE "nationality" = 'england' AND "goals" > 53

Question: What is the lowest ranking for Paul Mctiernan?
SQL: SELECT MIN("ranking") FROM player_stats_42 WHERE "name" = 'paul mctiernan'

Question: What are the years when the ranking is less than 8 with less than 66 goals and name is Paul McGee?
SQL: SELECT "years" FROM player_stats_42 WHERE "ranking" < 8 AND "goals" < 66 AND "name" = 'paul mcgee'