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_39 (home__2nd_leg_ VARCHAR, aggregate VARCHAR)
system
Which team played at home for the second leg and has an aggregate score of 2-4?
user
SELECT home__2nd_leg_ FROM table_name_39 WHERE aggregate = "2-4"
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_39 (home__2nd_leg_ VARCHAR, aggregate VARCHAR)<|im_end|>
<|im_start|>user
Which team played at home for the second leg and has an aggregate score of 2-4?<|im_end|>
