Table: players_stats_4
Columns: ranking
nationality
name
years
goals

Question: What country is the player who scored 27 goals from?
SQL: SELECT "nationality" FROM players_stats_4 WHERE "goals" = 27

Question: For the player that scored 27 goals, what years did he score them?
SQL: SELECT "years" FROM players_stats_4 WHERE "goals" = 27