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_70 (wins VARCHAR, losses VARCHAR, draws VARCHAR)
system
What is the total number of Wins, when Losses is "6", and when Draws is greater than "0"?
user
SELECT COUNT(wins) FROM table_name_70 WHERE losses = 6 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_70 (wins VARCHAR, losses VARCHAR, draws VARCHAR)<|im_end|>
<|im_start|>user
What is the total number of Wins, when Losses is "6", and when Draws is greater than "0"?<|im_end|>
