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_7 (draw INTEGER, played VARCHAR, lost VARCHAR)
system
What is the least ties when they played less than 14 games, and a lost less than 8 of them?
user
SELECT MIN(draw) FROM table_name_7 WHERE played < 14 AND lost < 8
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_7 (draw INTEGER, played VARCHAR, lost VARCHAR)<|im_end|>
<|im_start|>user
What is the least ties when they played less than 14 games, and a lost less than 8 of them?<|im_end|>
