What is the sum of the weight that all weightlifters managed to clean and jerk, among weightlifters who had a snatch of more than 95 and a Total of more than 200?
CREATE TABLE table_name_8 (_jerk VARCHAR, clean_ VARCHAR, total__kg_ VARCHAR, snatch VARCHAR)
SELECT COUNT(clean_) & _jerk FROM table_name_8 WHERE total__kg_ = 200 AND snatch > 95
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (_jerk VARCHAR, clean_ VARCHAR, total__kg_ VARCHAR, snatch VARCHAR) Question: What is the sum of the weight that all weightlifters managed to clean and jerk, among weightlifters who had a snatch of more than 95 and a Total of more than 200? [/INST] SELECT COUNT(clean_) & _jerk FROM table_name_8 WHERE total__kg_ = 200 AND snatch > 95 </s>