CREATE TABLE table_name_97 (party VARCHAR2, result VARCHAR2)

Which party had a Retired Democratic hold?
SELECT party FROM table_name_97 WHERE result = "retired democratic hold"
SELECT "party" FROM "table_name_97" WHERE "result" = "retired democratic hold"