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_66 (year INTEGER, venue VARCHAR, position VARCHAR, event VARCHAR)
system
What is the average Year, when Position is 9th, when Event is 100 m, and when Venue is Munich, Germany?
user
SELECT AVG(year) FROM table_name_66 WHERE position = "9th" AND event = "100 m" AND venue = "munich, germany"
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_66 (year INTEGER, venue VARCHAR, position VARCHAR, event VARCHAR)<|im_end|>
<|im_start|>user
What is the average Year, when Position is 9th, when Event is 100 m, and when Venue is Munich, Germany?<|im_end|>
