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_89 (pct INTEGER, years VARCHAR, wins VARCHAR)
system
Which Pct has Years of 1957–1970, and Wins smaller than 78?
user
SELECT SUM(pct) FROM table_name_89 WHERE years = "1957–1970" AND wins < 78
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_89 (pct INTEGER, years VARCHAR, wins VARCHAR)<|im_end|>
<|im_start|>user
Which Pct has Years of 1957–1970, and Wins smaller than 78?<|im_end|>
