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_24778847_2 (new_democratic VARCHAR, date_of_polling VARCHAR)
system
How many figures are given for the New Democratic for the polling range May 11–31, 2010?
user
SELECT COUNT(new_democratic) FROM table_24778847_2 WHERE date_of_polling = "May 11–31, 2010"
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_24778847_2 (new_democratic VARCHAR, date_of_polling VARCHAR)<|im_end|>
<|im_start|>user
How many figures are given for the New Democratic for the polling range May 11–31, 2010?<|im_end|>
