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_1473672_7 (pick__number INTEGER, player VARCHAR)
system
Serge Beaudoin was drafted when in the 1972 NHL draft
user
SELECT MIN(pick__number) FROM table_1473672_7 WHERE player = "Serge Beaudoin"
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_1473672_7 (pick__number INTEGER, player VARCHAR)<|im_end|>
<|im_start|>user
Serge Beaudoin was drafted when in the 1972 NHL draft<|im_end|>
