Table: election_results_2006_2
Columns: district
incumbent
party
first_elected
results
candidates

Question: How many districts have the incumbent, Charles Rangel? 
SQL: SELECT COUNT("district") FROM election_results_2006_2 WHERE "incumbent" = 'Charles Rangel'

Question: What is the party affiliation of New York 26? 
SQL: SELECT "party" FROM election_results_2006_2 WHERE "district" = 'New York 26'