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_1507806_1 (year VARCHAR, winning_score VARCHAR)
system
HOW MANY YEARS WAS IT FOR THE SCORE (76-73-79-72=300)?
user
SELECT COUNT(year) FROM table_1507806_1 WHERE winning_score = (76 - 73 - 79 - 72 = 300)
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_1507806_1 (year VARCHAR, winning_score VARCHAR)<|im_end|>
<|im_start|>user
HOW MANY YEARS WAS IT FOR THE SCORE (76-73-79-72=300)?<|im_end|>
