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_86 (points INTEGER, lost VARCHAR, drawn VARCHAR, name VARCHAR)
system
What is the average number of points with less than 1 draw and more than 11 losses for Ev Aich?
user
SELECT AVG(points) FROM table_name_86 WHERE drawn < 1 AND name = "ev aich" AND lost > 11
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_86 (points INTEGER, lost VARCHAR, drawn VARCHAR, name VARCHAR)<|im_end|>
<|im_start|>user
What is the average number of points with less than 1 draw and more than 11 losses for Ev Aich?<|im_end|>
