What is the number of total candidates when registered voters is 47742?
CREATE TABLE table_2676980_4 (total_candidates VARCHAR, registered_voters VARCHAR)
SELECT total_candidates FROM table_2676980_4 WHERE registered_voters = 47742
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2676980_4 (total_candidates VARCHAR, registered_voters VARCHAR) Question: What is the number of total candidates when registered voters is 47742? [/INST] SELECT total_candidates FROM table_2676980_4 WHERE registered_voters = 47742 </s>