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_41 (round INTEGER, overall VARCHAR, position VARCHAR, college VARCHAR)
system
What's the average round for the OT position from tulane college with an overall over 38?
user
SELECT AVG(round) FROM table_name_41 WHERE position = "ot" AND college = "tulane" AND overall > 38
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_41 (round INTEGER, overall VARCHAR, position VARCHAR, college VARCHAR)<|im_end|>
<|im_start|>user
What's the average round for the OT position from tulane college with an overall over 38?<|im_end|>
