Table: candidate_election_results
Columns: candidate
office
home_state
popular_vote
states_first_place
states_second_place
states_third_place

Question: How many different popular vote counts were there for the candidate Rick Perry?
SQL: SELECT COUNT("popular_vote") FROM candidate_election_results WHERE "candidate" = 'Rick Perry'

Question: Which office has 1 New Hampshire as a third place state?
SQL: SELECT "office" FROM candidate_election_results WHERE "states_third_place" = '1 New Hampshire'

Question: How many different popular vote counts are there for Rick Perry?
SQL: SELECT COUNT("popular_vote") FROM candidate_election_results WHERE "candidate" = 'Rick Perry'

Question: What office is Jon Huntsman a candidate for?
SQL: SELECT "office" FROM candidate_election_results WHERE "candidate" = 'Jon Huntsman'

Question: How many states-first place are there for the office of Governor?
SQL: SELECT COUNT("states_first_place") FROM candidate_election_results WHERE "office" = 'Governor'