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 (shot__percentage INTEGER, country VARCHAR, ends_lost VARCHAR)
system
What is the sum shot % when the country is finland, and an ends lost is larger than 49?
user
SELECT SUM(shot__percentage) FROM table_name_72 WHERE country = "finland" AND ends_lost > 49
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 (shot__percentage INTEGER, country VARCHAR, ends_lost VARCHAR)<|im_end|>
<|im_start|>user
What is the sum shot % when the country is finland, and an ends lost is larger than 49?<|im_end|>
