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_19982699_1 (_number INTEGER, producer VARCHAR, television_premiere VARCHAR)
system
How many numbers have Charles Salmon as the producer and January 27, 2007 was the television premiere?
user
SELECT MIN(_number) FROM table_19982699_1 WHERE producer = "Charles Salmon" AND television_premiere = "January 27, 2007"
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_19982699_1 (_number INTEGER, producer VARCHAR, television_premiere VARCHAR)<|im_end|>
<|im_start|>user
How many numbers have Charles Salmon as the producer and January 27, 2007 was the television premiere?<|im_end|>
