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_72 (ends_lost VARCHAR, shot_pct VARCHAR, ends_won VARCHAR)
system
How many ends lost when shot % is 88 and ends won are 31?
user
SELECT COUNT(ends_lost) FROM table_name_72 WHERE shot_pct = 88 AND ends_won = 31
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_72 (ends_lost VARCHAR, shot_pct VARCHAR, ends_won VARCHAR)<|im_end|>
<|im_start|>user
How many ends lost when shot % is 88 and ends won are 31?<|im_end|>
