Table: us_house_2000_election_2
Columns: district
incumbent
party
first_elected
results
candidates

Question: Name the first election for john mchugh
SQL: SELECT COUNT("first_elected") FROM us_house_2000_election_2 WHERE "incumbent" = 'John McHugh'

Question: Name the results for district new york 24
SQL: SELECT "results" FROM us_house_2000_election_2 WHERE "district" = 'New York 24'

Question: Name the district for carolyn mccarthy
SQL: SELECT "district" FROM us_house_2000_election_2 WHERE "incumbent" = 'Carolyn McCarthy'

Question: Name the number of party for new york 29
SQL: SELECT COUNT("party") FROM us_house_2000_election_2 WHERE "district" = 'New York 29'