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_84 (field_goals INTEGER, touchdowns VARCHAR)
system
What is the lowest number of field goals for a player with 3 touchdowns?
user
SELECT MIN(field_goals) FROM table_name_84 WHERE touchdowns = 3
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_84 (field_goals INTEGER, touchdowns VARCHAR)<|im_end|>
<|im_start|>user
What is the lowest number of field goals for a player with 3 touchdowns?<|im_end|>
