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_1670921_1 (fielding_team VARCHAR, wicket VARCHAR)
system
Which team is 9th in wickets?
user
SELECT fielding_team FROM table_1670921_1 WHERE wicket = "9th"
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_1670921_1 (fielding_team VARCHAR, wicket VARCHAR)<|im_end|>
<|im_start|>user
Which team is 9th in wickets?<|im_end|>
