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_2 (pick__number INTEGER, name VARCHAR, overall VARCHAR)
system
Which highest pick number's name was Adam Podlesh, when the overall was less than 101?
user
SELECT MAX(pick__number) FROM table_name_2 WHERE name = "adam podlesh" AND overall < 101
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_2 (pick__number INTEGER, name VARCHAR, overall VARCHAR)<|im_end|>
<|im_start|>user
Which highest pick number's name was Adam Podlesh, when the overall was less than 101?<|im_end|>
