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_24 (record VARCHAR, location VARCHAR, date VARCHAR)
system
What is Record, when Location is "Boston Garden", and when Date is "Fri. Nov. 9"?
user
SELECT record FROM table_name_24 WHERE location = "boston garden" AND date = "fri. nov. 9"
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_24 (record VARCHAR, location VARCHAR, date VARCHAR)<|im_end|>
<|im_start|>user
What is Record, when Location is "Boston Garden", and when Date is "Fri. Nov. 9"?<|im_end|>
