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_43 (total__kg_ INTEGER, bodyweight VARCHAR, clean_ VARCHAR, _jerk VARCHAR)
system
Which weightlifter, who had a bodyweight of less than 136.16 and a clean and jerk larger than 135, had the highest Total?
user
SELECT MAX(total__kg_) FROM table_name_43 WHERE bodyweight < 136.16 AND clean_ & _jerk > 135
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_43 (total__kg_ INTEGER, bodyweight VARCHAR, clean_ VARCHAR, _jerk VARCHAR)<|im_end|>
<|im_start|>user
Which weightlifter, who had a bodyweight of less than 136.16 and a clean and jerk larger than 135, had the highest Total?<|im_end|>
