Table: election_results_1990_2
Columns: district
incumbent
party
elected
status
opponent

Question: What party did incumbent Howard Coble belong to?
SQL: SELECT "party" FROM election_results_1990_2 WHERE "incumbent" = 'Howard Coble'

Question: What party did incumbent Stephen L. Neal belong to? 
SQL: SELECT "party" FROM election_results_1990_2 WHERE "incumbent" = 'Stephen L. Neal'

Question: In how many districts was the democratic incumbent elected in 1974? 
SQL: SELECT COUNT("district") FROM election_results_1990_2 WHERE "party" = 'Democratic' AND "elected" = 1974

Question: What year was incumbent Martin Lancaster elected? 
SQL: SELECT MIN("elected") FROM election_results_1990_2 WHERE "incumbent" = 'Martin Lancaster'