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_48 (overall INTEGER, school_club_team VARCHAR, round VARCHAR)
system
What is the highest overall rank of any Tennessee State player drafted before round 10?
user
SELECT MIN(overall) FROM table_name_48 WHERE school_club_team = "tennessee state" AND round < 10
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_48 (overall INTEGER, school_club_team VARCHAR, round VARCHAR)<|im_end|>
<|im_start|>user
What is the highest overall rank of any Tennessee State player drafted before round 10?<|im_end|>
