What is the total for the player with more snatches than 87.5 and bodyweight more than 74.8?
CREATE TABLE table_name_7 (total__kg_ INTEGER, snatch VARCHAR, bodyweight VARCHAR)
SELECT AVG(total__kg_) FROM table_name_7 WHERE snatch > 87.5 AND bodyweight > 74.8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (total__kg_ INTEGER, snatch VARCHAR, bodyweight VARCHAR) Question: What is the total for the player with more snatches than 87.5 and bodyweight more than 74.8? [/INST] SELECT AVG(total__kg_) FROM table_name_7 WHERE snatch > 87.5 AND bodyweight > 74.8 </s>