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_25 (laps INTEGER, grid VARCHAR, time_retired VARCHAR, constructor VARCHAR)
system
Where the time/retired is +1 lap, the constructor is BRM, and the grid is above 1, what's the highest laps recorded?
user
SELECT MAX(laps) FROM table_name_25 WHERE time_retired = "+1 lap" AND constructor = "brm" AND grid > 1
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_25 (laps INTEGER, grid VARCHAR, time_retired VARCHAR, constructor VARCHAR)<|im_end|>
<|im_start|>user
Where the time/retired is +1 lap, the constructor is BRM, and the grid is above 1, what's the highest laps recorded?<|im_end|>
