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_81 (total INTEGER, year_s__won VARCHAR, to_par VARCHAR)
system
What is the sum of Total, when Year(s) Won is "1966 , 1970 , 1978", and when To par is less than 4?
user
SELECT SUM(total) FROM table_name_81 WHERE year_s__won = "1966 , 1970 , 1978" AND to_par < 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_81 (total INTEGER, year_s__won VARCHAR, to_par VARCHAR)<|im_end|>
<|im_start|>user
What is the sum of Total, when Year(s) Won is "1966 , 1970 , 1978", and when To par is less than 4?<|im_end|>
