Table: election_results_1928_2
Columns: district
incumbent
party
first_elected
result
candidates

Question: what is the total number of results where the district is south carolina 5?
SQL: SELECT COUNT("result") FROM election_results_1928_2 WHERE "district" = 'South Carolina 5'

Question: who is the candidate in district south carolina 2?
SQL: SELECT "candidates" FROM election_results_1928_2 WHERE "district" = 'South Carolina 2'

Question: what year was william francis stevenson first elected?
SQL: SELECT "first_elected" FROM election_results_1928_2 WHERE "incumbent" = 'William Francis Stevenson'