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_9 (runners_up VARCHAR, winners VARCHAR, years_runner_up VARCHAR)
system
How many runners up for the team with under 1 win and a Years runner-up of 1985 , 1996?
user
SELECT runners_up FROM table_name_9 WHERE winners < 1 AND years_runner_up = "1985 , 1996"
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_9 (runners_up VARCHAR, winners VARCHAR, years_runner_up VARCHAR)<|im_end|>
<|im_start|>user
How many runners up for the team with under 1 win and a Years runner-up of 1985 , 1996?<|im_end|>
