Name the average clean and jerk for snatch of 140 and total kg less than 315
CREATE TABLE table_name_10 (_jerk VARCHAR, clean_ INTEGER, snatch VARCHAR, total__kg_ VARCHAR)
SELECT AVG(clean_) & _jerk FROM table_name_10 WHERE snatch = 140 AND total__kg_ < 315
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_10 (_jerk VARCHAR, clean_ INTEGER, snatch VARCHAR, total__kg_ VARCHAR) Question: Name the average clean and jerk for snatch of 140 and total kg less than 315 [/INST] SELECT AVG(clean_) & _jerk FROM table_name_10 WHERE snatch = 140 AND total__kg_ < 315 </s>