Table: nz_byelections
Columns: by_election
electorate
date
incumbent
reason
winner

Question: When james rutherford is the incumbent how many dates are there?
SQL: SELECT COUNT("date") FROM nz_byelections WHERE "incumbent" = 'James Rutherford'

Question: When edward shaw is the winner what is the date?
SQL: SELECT "date" FROM nz_byelections WHERE "winner" = 'Edward Shaw'

Question: When peninsula is the electorate what is the reason?
SQL: SELECT "reason" FROM nz_byelections WHERE "electorate" = 'Peninsula'

Question: When james seaton is the incumbent what is the reason?
SQL: SELECT "reason" FROM nz_byelections WHERE "incumbent" = 'James Seaton'