Table: election_results_1998_4
Columns: district
incumbent
party
first_elected
results
candidates

Question: What party is John McHugh a member of?
SQL: SELECT "party" FROM election_results_1998_4 WHERE "incumbent" = 'John McHugh'

Question: What's the party elected in the district that first elected in 1990?
SQL: SELECT "party" FROM election_results_1998_4 WHERE "first_elected" = '1990'

Question: What's the first elected year of the district that Ed Towns is an incumbent of?
SQL: SELECT "first_elected" FROM election_results_1998_4 WHERE "incumbent" = 'Ed Towns'

Question: How many elections have resulted in retired democratic hold?
SQL: SELECT COUNT("party") FROM election_results_1998_4 WHERE "results" = 'Retired Democratic hold'

Question: What were the candidates in the district that first elected in 1980?
SQL: SELECT "candidates" FROM election_results_1998_4 WHERE "first_elected" = '1980'