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_27 (loss VARCHAR, avg_g VARCHAR, gain VARCHAR, long VARCHAR)
system
How much Loss has a Gain smaller than 1571, and a Long smaller than 47, and an Avg/G of 36.4?
user
SELECT COUNT(loss) FROM table_name_27 WHERE gain < 1571 AND long < 47 AND avg_g = 36.4
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_27 (loss VARCHAR, avg_g VARCHAR, gain VARCHAR, long VARCHAR)<|im_end|>
<|im_start|>user
How much Loss has a Gain smaller than 1571, and a Long smaller than 47, and an Avg/G of 36.4?<|im_end|>
