Table: nz_7th_parliament_elections
Columns: by_election
electorate
date
incumbent
reason
winner

Question: When arthur collins is the winner what is the reason?
SQL: SELECT "reason" FROM nz_7th_parliament_elections WHERE "winner" = 'Arthur Collins'

Question: When ihaia tainui is the incumbent what is the date?
SQL: SELECT "date" FROM nz_7th_parliament_elections WHERE "incumbent" = 'Ihaia Tainui'

Question: When rangitikei is the electorate who is the winner?
SQL: SELECT "winner" FROM nz_7th_parliament_elections WHERE "electorate" = 'Rangitikei'

Question: When waikaia is the electorate what is the highest by-election?
SQL: SELECT MAX("by_election") FROM nz_7th_parliament_elections WHERE "electorate" = 'Waikaia'

Question: When 1881 is the by-election and death is the reason who is the incumbent?
SQL: SELECT "incumbent" FROM nz_7th_parliament_elections WHERE "reason" = 'Death' AND "by_election" = 1881