user: ### NOW ANSWER:
Question: Which Captain 2 has a Result of Ireland by 8 runs?
Columns: ['Date', 'Captain 1', 'Team 2', 'Captain 2', 'Venue', 'Result']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['3–6 September', 'Irving Romaine', 'Namibia', 'Louis Burger', 'National Stadium , Hamilton', 'Namibia by 103 runs']
SQL:

assistant: SELECT "Captain 2" FROM "Table" WHERE "Result" = 'Ireland by 8 runs';