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_92 (rides INTEGER, bonus_pts VARCHAR, matches VARCHAR)
system
How many rides did it take to get less than 3 bonus pts in no more than 7 matches?
user
SELECT MIN(rides) FROM table_name_92 WHERE bonus_pts < 3 AND matches < 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_92 (rides INTEGER, bonus_pts VARCHAR, matches VARCHAR)<|im_end|>
<|im_start|>user
How many rides did it take to get less than 3 bonus pts in no more than 7 matches?<|im_end|>
