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_51 (apps INTEGER, rank VARCHAR, goals VARCHAR)
system
What are the apps for less than 61 goals and before rank 6?
user
SELECT SUM(apps) FROM table_name_51 WHERE rank < 6 AND goals < 61
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_51 (apps INTEGER, rank VARCHAR, goals VARCHAR)<|im_end|>
<|im_start|>user
What are the apps for less than 61 goals and before rank 6?<|im_end|>
