What party is the person who was first elected in 2000 and was re-elected?
CREATE TABLE table_name_50 (party VARCHAR, results VARCHAR, first_elected VARCHAR)
SELECT party FROM table_name_50 WHERE results = "re-elected" AND first_elected = 2000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (party VARCHAR, results VARCHAR, first_elected VARCHAR) Question: What party is the person who was first elected in 2000 and was re-elected? [/INST] SELECT party FROM table_name_50 WHERE results = "re-elected" AND first_elected = 2000 </s>