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_88 (points INTEGER, games VARCHAR, goalsagainst VARCHAR, season VARCHAR)
system
Goalsagainst of 285, and a Season of 2006–07, and a Games smaller than 70 has what average points?
user
SELECT AVG(points) FROM table_name_88 WHERE goalsagainst = 285 AND season = "2006–07" AND games < 70
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_88 (points INTEGER, games VARCHAR, goalsagainst VARCHAR, season VARCHAR)<|im_end|>
<|im_start|>user
Goalsagainst of 285, and a Season of 2006–07, and a Games smaller than 70 has what average points?<|im_end|>
