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_10592536_8 (date_of_appointment VARCHAR, date_of_vacancy VARCHAR)
system
What is the date of appointment when the date of vacancy is 21 december 2007?
user
SELECT date_of_appointment FROM table_10592536_8 WHERE date_of_vacancy = "21 December 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_10592536_8 (date_of_appointment VARCHAR, date_of_vacancy VARCHAR)<|im_end|>
<|im_start|>user
What is the date of appointment when the date of vacancy is 21 december 2007?<|im_end|>
