Table: election_results_2006_2
Columns: district
incumbent
party
first_elected
results

Question: What were the results for the incumbent from Iowa 2 district?
SQL: SELECT "results" FROM election_results_2006_2 WHERE "district" = 'iowa 2'

Question: Who is the incumbent that has been in office since before 1996 and was again re-elected?
SQL: SELECT "incumbent" FROM election_results_2006_2 WHERE "results" = 're-elected' AND "first_elected" < 1996

Question: From which party is the incumbent who was first elected to office in 1990?
SQL: SELECT "party" FROM election_results_2006_2 WHERE "first_elected" = 1990

Question: In what year did the Democratic incumbent that was re-elected first take office?
SQL: SELECT "first_elected" FROM election_results_2006_2 WHERE "results" = 're-elected' AND "party" = 'democratic'