Who had 0 total votes in the purple team?
CREATE TABLE table_name_18 (status VARCHAR, total_votes VARCHAR, couples_team VARCHAR)
SELECT status FROM table_name_18 WHERE total_votes = "0" AND couples_team = "purple team"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (status VARCHAR, total_votes VARCHAR, couples_team VARCHAR) Question: Who had 0 total votes in the purple team? [/INST] SELECT status FROM table_name_18 WHERE total_votes = "0" AND couples_team = "purple team" </s>