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_15 (year INTEGER, venue VARCHAR)
system
What is the average year for Ponce, Puerto Rico events?
user
SELECT AVG(year) FROM table_name_15 WHERE venue = "ponce, puerto rico"
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_15 (year INTEGER, venue VARCHAR)<|im_end|>
<|im_start|>user
What is the average year for Ponce, Puerto Rico events?<|im_end|>
