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_61 (pick__number VARCHAR, team_from VARCHAR, league_from VARCHAR, nationality VARCHAR)
system
Which Pick # has a League from of ontario hockey league, a Nationality of united states, and a Team from of brampton battalion?
user
SELECT COUNT(pick__number) FROM table_name_61 WHERE league_from = "ontario hockey league" AND nationality = "united states" AND team_from = "brampton battalion"
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_61 (pick__number VARCHAR, team_from VARCHAR, league_from VARCHAR, nationality VARCHAR)<|im_end|>
<|im_start|>user
Which Pick # has a League from of ontario hockey league, a Nationality of united states, and a Team from of brampton battalion?<|im_end|>
