Table: election_results_2006_8
Columns: district
incumbent
party
first_elected
results

Question: What is Party, when District is "Tennessee 8"?
SQL: SELECT "party" FROM election_results_2006_8 WHERE "district" = 'tennessee 8'

Question: What is the total number of First Elected, when Party is "Democratic", and when District is "Tennessee 5"?
SQL: SELECT COUNT("first_elected") FROM election_results_2006_8 WHERE "party" = 'democratic' AND "district" = 'tennessee 5'

Question: What is the lowest First Elected, when Results is "Re-elected", and when Incumbent is "Lincoln Davis"?
SQL: SELECT MIN("first_elected") FROM election_results_2006_8 WHERE "results" = 're-elected' AND "incumbent" = 'lincoln davis'

Question: What is the highest First Elected, when Results is "Re-elected", and when Incumbent is "Lincoln Davis"?
SQL: SELECT MAX("first_elected") FROM election_results_2006_8 WHERE "results" = 're-elected' AND "incumbent" = 'lincoln davis'