CREATE TABLE table_76553 ("Date" CLOB, "Captain 1" CLOB, "Team 2" CLOB, "Captain 2" CLOB, "Venue" CLOB, "Result" CLOB)

Which Captain 2 has a Result of ireland by 8 runs?
SELECT "Captain 2" FROM table_76553 WHERE "Result" = 'ireland by 8 runs'
SELECT "Captain 2" FROM "table_76553" WHERE "Result" = 'ireland by 8 runs'