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_13 (points INTEGER, goals_against VARCHAR, coach VARCHAR, tied VARCHAR, games VARCHAR)
system
What is the points average when the tied is greater than 8, less than 82 games and the coach of Bryan Mclay † Morris Lallo ‡ Gerry Moore ‡, and greater than 322 goals?
user
SELECT AVG(points) FROM table_name_13 WHERE tied > 8 AND games < 82 AND coach = "bryan mclay † morris lallo ‡ gerry moore ‡" AND goals_against > 322
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_13 (points INTEGER, goals_against VARCHAR, coach VARCHAR, tied VARCHAR, games VARCHAR)<|im_end|>
<|im_start|>user
What is the points average when the tied is greater than 8, less than 82 games and the coach of Bryan Mclay † Morris Lallo ‡ Gerry Moore ‡, and greater than 322 goals?<|im_end|>
