Table: premier_league_teams
Columns: team
manager
captain
kit_manufacturer
shirt_sponsor

Question: Who is the captain of the manchester city team?
SQL: SELECT "captain" FROM premier_league_teams WHERE "team" = 'manchester city'

Question: Which captain's manager is Joe Royle?
SQL: SELECT "captain" FROM premier_league_teams WHERE "manager" = 'joe royle'