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_4 (pick__number VARCHAR, round VARCHAR, college VARCHAR)
system
How many Picks have a Round larger than 8, and a College of fresno state?
user
SELECT COUNT(pick__number) FROM table_name_4 WHERE round > 8 AND college = "fresno state"
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_4 (pick__number VARCHAR, round VARCHAR, college VARCHAR)<|im_end|>
<|im_start|>user
How many Picks have a Round larger than 8, and a College of fresno state?<|im_end|>
