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_10 (home_team VARCHAR, score VARCHAR, away_team VARCHAR)
system
What home team has a score of 2–1, when the away team was Telford United?
user
SELECT home_team FROM table_name_10 WHERE score = "2–1" AND away_team = "telford united"
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_10 (home_team VARCHAR, score VARCHAR, away_team VARCHAR)<|im_end|>
<|im_start|>user
What home team has a score of 2–1, when the away team was Telford United?<|im_end|>
