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_76 (drawn INTEGER, points VARCHAR, played VARCHAR)
system
What is the average drawn number of the team with less than 70 points and less than 46 played?
user
SELECT AVG(drawn) FROM table_name_76 WHERE points < 70 AND played < 46
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_76 (drawn INTEGER, points VARCHAR, played VARCHAR)<|im_end|>
<|im_start|>user
What is the average drawn number of the team with less than 70 points and less than 46 played?<|im_end|>
