CREATE TABLE table_name_50 (party VARCHAR2, results VARCHAR2, first_elected VARCHAR2)

What party is the person who was first elected in 2000 and was re-elected?
SELECT party FROM table_name_50 WHERE results = "re-elected" AND first_elected = 2000
SELECT "party" FROM "table_name_50" WHERE "first_elected" = 2000 AND "re-elected" = "results"