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_99 (goals_for INTEGER, draws VARCHAR, points VARCHAR, losses VARCHAR, wins VARCHAR)
system
What is the average number of goals for entries with more than 12 losses, more than 10 wins, more than 3 draws, and fewer than 29 points?
user
SELECT AVG(goals_for) FROM table_name_99 WHERE losses > 12 AND wins > 10 AND points < 29 AND draws > 3
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_99 (goals_for INTEGER, draws VARCHAR, points VARCHAR, losses VARCHAR, wins VARCHAR)<|im_end|>
<|im_start|>user
What is the average number of goals for entries with more than 12 losses, more than 10 wins, more than 3 draws, and fewer than 29 points?<|im_end|>
