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_91 (total_goals INTEGER, league_cup_apps VARCHAR, fa_cup_goals VARCHAR, name VARCHAR)
system
What's the total goals for Alan Sweeney having 0 FA Cup goals and fewer than 0 League Cup apps?
user
SELECT AVG(total_goals) FROM table_name_91 WHERE fa_cup_goals = 0 AND name = "alan sweeney" AND league_cup_apps < 0
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_91 (total_goals INTEGER, league_cup_apps VARCHAR, fa_cup_goals VARCHAR, name VARCHAR)<|im_end|>
<|im_start|>user
What's the total goals for Alan Sweeney having 0 FA Cup goals and fewer than 0 League Cup apps?<|im_end|>
