Table: players_stats
Columns: player
country
caps
goals
years_active

Question: What were the goals when the caps were set at 48?
SQL: SELECT "goals" FROM players_stats WHERE "caps" = 48

Question: How many caps did the player Mile Sterjovski have?
SQL: SELECT "caps" FROM players_stats WHERE "player" = 'mile sterjovski'

Question: What are the goals of Mile Sterjovski as a player?
SQL: SELECT "goals" FROM players_stats WHERE "player" = 'mile sterjovski'

Question: How many caps did Mitchell Duke have overall?
SQL: SELECT COUNT("caps") FROM players_stats WHERE "player" = 'mitchell duke'