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_1 (second INTEGER, first VARCHAR, total VARCHAR, premier VARCHAR)
system
What is the sum of Second, when Total is less than 70, when Premier is less than 20, and when First is greater than 18?
user
SELECT SUM(second) FROM table_name_1 WHERE total < 70 AND premier < 20 AND first > 18
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_1 (second INTEGER, first VARCHAR, total VARCHAR, premier VARCHAR)<|im_end|>
<|im_start|>user
What is the sum of Second, when Total is less than 70, when Premier is less than 20, and when First is greater than 18?<|im_end|>
