Table: football_international_players
Columns: player
cap_s
goal_s
international_debut
club_s

Question: How many items are listed under caps when burnley is the club team?
SQL: SELECT COUNT("cap_s") FROM football_international_players WHERE "club_s" = 'Burnley'

Question: What club did the championship player come from who had 10 goals?
SQL: SELECT "club_s" FROM football_international_players WHERE "goal_s" = 10

Question: How many goals did the player from Ipswich town score?
SQL: SELECT MIN("goal_s") FROM football_international_players WHERE "club_s" = 'Ipswich Town'