Table: election_results_2006_2
Columns: district
incumbent
party
first_elected
results
candidates

Question: How many times was Mike McIntyre elected?
SQL: SELECT COUNT("results") FROM election_results_2006_2 WHERE "incumbent" = 'Mike McIntyre'

Question: Which party was elected first in 1998?
SQL: SELECT "party" FROM election_results_2006_2 WHERE "first_elected" = 1998

Question: How many times did Robin Hayes run?
SQL: SELECT COUNT("candidates") FROM election_results_2006_2 WHERE "incumbent" = 'Robin Hayes'