Table: us_house_2012_election
Columns: district
incumbent
party
first_elected
result
candidates

Question: Name the first elected for alabama 3
SQL: SELECT COUNT("first_elected") FROM us_house_2012_election WHERE "district" = 'Alabama 3'

Question: Name the party for spencer bachus
SQL: SELECT "party" FROM us_house_2012_election WHERE "incumbent" = 'Spencer Bachus'

Question: Name the district for mike rogers
SQL: SELECT "district" FROM us_house_2012_election WHERE "incumbent" = 'Mike Rogers'

Question: Name the district for spencer bachus
SQL: SELECT "district" FROM us_house_2012_election WHERE "incumbent" = 'Spencer Bachus'