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_name_54 (birthdate VARCHAR, birthplace VARCHAR)
system
On what date was the player from Melrose, Massachusetts born?
user
SELECT birthdate FROM table_name_54 WHERE birthplace = "melrose, massachusetts"
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_name_54 (birthdate VARCHAR, birthplace VARCHAR)<|im_end|>
<|im_start|>user
On what date was the player from Melrose, Massachusetts born?<|im_end|>
