Table: house_1990_elections
Columns: district
incumbent
party
elected
status
opponent

Question: How many incumbents represent district California 34?
SQL: SELECT COUNT("incumbent") FROM house_1990_elections WHERE "district" = 'California 34'

Question: What is the elected status of the Democratic party in 1989?
SQL: SELECT "status" FROM house_1990_elections WHERE "party" = 'Democratic' AND "elected" = '1989'

Question: Who are the opponents in district California 9?
SQL: SELECT "opponent" FROM house_1990_elections WHERE "district" = 'California 9'

Question: Who are the incumbents elected in 1974?
SQL: SELECT "incumbent" FROM house_1990_elections WHERE "elected" = '1974'