Table: election_results_2006_4
Columns: district
incumbent
party
first_elected
results

Question: What is Illinois 13 District's Party?
SQL: SELECT "party" FROM election_results_2006_4 WHERE "district" = 'illinois 13'

Question: What is re-elected Incumbent Jerry Costello's First elected date?
SQL: SELECT MIN("first_elected") FROM election_results_2006_4 WHERE "results" = 're-elected' AND "incumbent" = 'jerry costello'

Question: What is the Party of District of Illinois 19 with an Incumbent First elected in 1996?
SQL: SELECT "party" FROM election_results_2006_4 WHERE "first_elected" = 1996 AND "district" = 'illinois 19'

Question: What is the First Elected date of the Republican with Results of retired republican hold?
SQL: SELECT MIN("first_elected") FROM election_results_2006_4 WHERE "party" = 'republican' AND "results" = 'retired republican hold'