user: ### NOW ANSWER:
Question: Which captain's manager is Joe Royle?
Columns: ['Team', 'Manager', 'Captain', 'Kit manufacturer', 'Shirt sponsor']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Arsenal', 'Arsène Wenger', 'Tony Adams', 'Nike', 'Dreamcast']
SQL:

assistant: SELECT "Captain" FROM "Table" WHERE "Manager" = 'Joe Royle';