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_26 (wins INTEGER, draws VARCHAR, played VARCHAR)
system
What is the fewest number of wins that had fewer than 7 draws and more than 30 played?
user
SELECT MIN(wins) FROM table_name_26 WHERE draws < 7 AND played > 30
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_26 (wins INTEGER, draws VARCHAR, played VARCHAR)<|im_end|>
<|im_start|>user
What is the fewest number of wins that had fewer than 7 draws and more than 30 played?<|im_end|>
