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_1 (drawn VARCHAR, points_for VARCHAR)
system
How many matches were drawn by a team with 447 points?
user
SELECT drawn FROM table_name_1 WHERE points_for = "447"
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_1 (drawn VARCHAR, points_for VARCHAR)<|im_end|>
<|im_start|>user
How many matches were drawn by a team with 447 points?<|im_end|>
