Who is the captain for the manufacturer Pony, and the manager Harry Redknapp?
CREATE TABLE table_name_59 (captain VARCHAR, kit_manufacturer VARCHAR, manager VARCHAR)
SELECT captain FROM table_name_59 WHERE kit_manufacturer = "pony" AND manager = "harry redknapp"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (captain VARCHAR, kit_manufacturer VARCHAR, manager VARCHAR) Question: Who is the captain for the manufacturer Pony, and the manager Harry Redknapp? [/INST] SELECT captain FROM table_name_59 WHERE kit_manufacturer = "pony" AND manager = "harry redknapp" </s>