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_30 (score VARCHAR, date VARCHAR, home VARCHAR, visitor VARCHAR)
system
What is the Score of the Chicago Black Hawks Home game with the Visiting Vancouver Canucks on November 17?
user
SELECT score FROM table_name_30 WHERE home = "chicago black hawks" AND visitor = "vancouver canucks" AND date = "november 17"
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_30 (score VARCHAR, date VARCHAR, home VARCHAR, visitor VARCHAR)<|im_end|>
<|im_start|>user
What is the Score of the Chicago Black Hawks Home game with the Visiting Vancouver Canucks on November 17?<|im_end|>
