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_31 (partner VARCHAR, score_in_the_final VARCHAR)
system
Who was the partner for the match with a score in the final of 4–6, 6–7?
user
SELECT partner FROM table_name_31 WHERE score_in_the_final = "4–6, 6–7"
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_31 (partner VARCHAR, score_in_the_final VARCHAR)<|im_end|>
<|im_start|>user
Who was the partner for the match with a score in the final of 4–6, 6–7?<|im_end|>
