Table: us_election_results
Columns: district
incumbent
party
first_elected
result
candidates

Question: What kind of party is the district in Alabama 1?
SQL: SELECT "party" FROM us_election_results WHERE "district" = 'Alabama 1'

Question: How many in lost renomination results were elected first?
SQL: SELECT "first_elected" FROM us_election_results WHERE "result" = 'Lost renomination'

Question: How many in total were elected first in lost renomination?
SQL: SELECT COUNT("first_elected") FROM us_election_results WHERE "result" = 'Lost renomination'