SCHEMA:
CREATE TABLE table_name_87 (captain_2 VARCHAR, result VARCHAR)
USER:
Which Captain 2 has a Result of ireland by 8 runs?

QUERY:
SELECT captain_2 FROM table_name_87 WHERE result = "ireland by 8 runs"