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_47 (events INTEGER, tournament VARCHAR, top_25 VARCHAR)
system
What is the total of events when the tournament was U.S. Open and the Top-25 was less than 1?
user
SELECT SUM(events) FROM table_name_47 WHERE tournament = "u.s. open" AND top_25 < 1
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_47 (events INTEGER, tournament VARCHAR, top_25 VARCHAR)<|im_end|>
<|im_start|>user
What is the total of events when the tournament was U.S. Open and the Top-25 was less than 1?<|im_end|>
