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_5 (appearances VARCHAR, goals VARCHAR)
system
What is the amount of apperances of the person who had 36 goals?
user
SELECT appearances FROM table_name_5 WHERE goals = 36
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_5 (appearances VARCHAR, goals VARCHAR)<|im_end|>
<|im_start|>user
What is the amount of apperances of the person who had 36 goals?<|im_end|>
