Table: election_results_1994_2
Columns: district
incumbent
party
first_elected
status
opponent

Question: What party does ron klink represent?
SQL: SELECT "party" FROM election_results_1994_2 WHERE "incumbent" = 'Ron Klink'

Question: Who was in the election that was for incumbent bud shuster's seat?
SQL: SELECT "opponent" FROM election_results_1994_2 WHERE "incumbent" = 'Bud Shuster'

Question: What district had someone first elected in 1982?
SQL: SELECT "district" FROM election_results_1994_2 WHERE "first_elected" = 1982

Question: How many republican incumbents first elected in 1974?
SQL: SELECT COUNT("incumbent") FROM election_results_1994_2 WHERE "party" = 'Republican' AND "first_elected" = 1974

Question: What was the result of the election where william f. goodling was the incumbent?
SQL: SELECT "status" FROM election_results_1994_2 WHERE "incumbent" = 'William F. Goodling'