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_21 (score VARCHAR, goal VARCHAR, result VARCHAR, competition VARCHAR)
system
Which Score has a Result of 2–1, and a Competition of friendly, and a Goal smaller than 17?
user
SELECT score FROM table_name_21 WHERE result = "2–1" AND competition = "friendly" AND goal < 17
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_21 (score VARCHAR, goal VARCHAR, result VARCHAR, competition VARCHAR)<|im_end|>
<|im_start|>user
Which Score has a Result of 2–1, and a Competition of friendly, and a Goal smaller than 17?<|im_end|>
