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_17 (wins INTEGER, losses VARCHAR, draws VARCHAR)
system
What was the greatest number of wins for a team that had 7 losses and more than 0 draws?
user
SELECT MAX(wins) FROM table_name_17 WHERE losses = 7 AND draws > 0
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_17 (wins INTEGER, losses VARCHAR, draws VARCHAR)<|im_end|>
<|im_start|>user
What was the greatest number of wins for a team that had 7 losses and more than 0 draws?<|im_end|>
