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_12 (club VARCHAR, third VARCHAR, runners_up VARCHAR, winners VARCHAR)
system
Which club has 1 runners-up with 0 winners and 2 third place earned?
user
SELECT club FROM table_name_12 WHERE runners_up = 1 AND winners = 0 AND third = 2
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_12 (club VARCHAR, third VARCHAR, runners_up VARCHAR, winners VARCHAR)<|im_end|>
<|im_start|>user
Which club has 1 runners-up with 0 winners and 2 third place earned?<|im_end|>
