Which Captain 2 has a Result of ireland by 8 runs?
CREATE TABLE table_name_87 (captain_2 VARCHAR, result VARCHAR)
SELECT captain_2 FROM table_name_87 WHERE result = "ireland by 8 runs"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_87 (captain_2 VARCHAR, result VARCHAR) Question: Which Captain 2 has a Result of ireland by 8 runs? [/INST] SELECT captain_2 FROM table_name_87 WHERE result = "ireland by 8 runs" </s>