What is the average weight of the player with a height of 180 cm and plays the d position?
CREATE TABLE table_name_53 (weight__kg_ INTEGER, height__cm_ VARCHAR, position VARCHAR)
SELECT AVG(weight__kg_) FROM table_name_53 WHERE height__cm_ = 180 AND position = "d"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_53 (weight__kg_ INTEGER, height__cm_ VARCHAR, position VARCHAR) Question: What is the average weight of the player with a height of 180 cm and plays the d position? [/INST] SELECT AVG(weight__kg_) FROM table_name_53 WHERE height__cm_ = 180 AND position = "d" </s>