Table: us_house_2006_election_4
Columns: district
incumbent
party
first_elected
results

Question: What is the average first elected for the district South Carolina 2?
SQL: SELECT AVG("first_elected") FROM us_house_2006_election_4 WHERE "district" = 'south carolina 2'

Question: Who was the first elected for the republican party?
SQL: SELECT "first_elected" FROM us_house_2006_election_4 WHERE "party" = 'republican'

Question: What party has the South Carolina 2 district?
SQL: SELECT "party" FROM us_house_2006_election_4 WHERE "district" = 'south carolina 2'