Table: election_results_2000_5
Columns: district
incumbent
party
first_elected
results
candidates

Question: what is the earliest first elected with the results re-elected in the district south carolina 3?
SQL: SELECT MAX("first_elected") FROM election_results_2000_5 WHERE "results" = 'Re-elected' AND "district" = 'South Carolina 3'

Question: what is the party with the incumbent jim demint?
SQL: SELECT "party" FROM election_results_2000_5 WHERE "incumbent" = 'Jim DeMint'

Question: what is the party for the district south carolina 4?
SQL: SELECT "party" FROM election_results_2000_5 WHERE "district" = 'South Carolina 4'

Question: what is the party when candidates is jim demint (r) 80%?
SQL: SELECT "party" FROM election_results_2000_5 WHERE "candidates" = 'Jim DeMint (R) 80%'

Question: what is the party when candidates is jim demint (r) 80%?
SQL: SELECT "party" FROM election_results_2000_5 WHERE "candidates" = 'Jim DeMint (R) 80%'

Question: who are the candidates when the incumbent is lindsey graham?
SQL: SELECT "candidates" FROM election_results_2000_5 WHERE "incumbent" = 'Lindsey Graham'