You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_2668347_14 (party VARCHAR, candidates VARCHAR)
system
how many times were the candidates thomas h. hubbard (dr) 51.5% simeon ford (f) 48.4%?
user
SELECT COUNT(party) FROM table_2668347_14 WHERE candidates = "Thomas H. Hubbard (DR) 51.5% Simeon Ford (F) 48.4%"
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_2668347_14 (party VARCHAR, candidates VARCHAR)<|im_end|>
<|im_start|>user
how many times were the candidates thomas h. hubbard (dr) 51.5% simeon ford (f) 48.4%?<|im_end|>
