Table: cricket_2008_09
Columns: date
captain_1
team_2
captain_2
venue
result

Question: Which Result has a Captain 1 of louis burger, and a Date of 30 october–2 november?
SQL: SELECT "result" FROM cricket_2008_09 WHERE "captain_1" = 'louis burger' AND "date" = '30 october–2 november'

Question: Which Team 2 has a Captain 1 of final?
SQL: SELECT "team_2" FROM cricket_2008_09 WHERE "captain_1" = 'final'

Question: Which Captain 2 has a Result of ireland by 8 runs?
SQL: SELECT "captain_2" FROM cricket_2008_09 WHERE "result" = 'ireland by 8 runs'

Question: Which Result has a Captain 2 of louis burger?
SQL: SELECT "result" FROM cricket_2008_09 WHERE "captain_2" = 'louis burger'

Question: Which Captain 2 has a Result of final?
SQL: SELECT "captain_2" FROM cricket_2008_09 WHERE "result" = 'final'