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_89 (rank INTEGER, goals VARCHAR, matches VARCHAR, name VARCHAR)
system
What was Des Dickson's lowest rank for matches smaller than 285 and less than 219 goals?
user
SELECT MIN(rank) FROM table_name_89 WHERE matches < 285 AND name = "des dickson" AND goals < 219
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_89 (rank INTEGER, goals VARCHAR, matches VARCHAR, name VARCHAR)<|im_end|>
<|im_start|>user
What was Des Dickson's lowest rank for matches smaller than 285 and less than 219 goals?<|im_end|>
