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_11 (date VARCHAR, visitor VARCHAR, attendance VARCHAR)
system
What is the date of the game where the vistor team was the Knicks and more than 18,165 were in attendance?
user
SELECT date FROM table_name_11 WHERE visitor = "knicks" AND attendance > 18 OFFSET 165
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_11 (date VARCHAR, visitor VARCHAR, attendance VARCHAR)<|im_end|>
<|im_start|>user
What is the date of the game where the vistor team was the Knicks and more than 18,165 were in attendance?<|im_end|>
