List the rank of the player that left due to right wrist surgery?
CREATE TABLE table_24431264_18 (rank VARCHAR, withdrew_due_to VARCHAR)
SELECT rank FROM table_24431264_18 WHERE withdrew_due_to = "right wrist surgery"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_24431264_18 (rank VARCHAR, withdrew_due_to VARCHAR) Question: List the rank of the player that left due to right wrist surgery? [/INST] SELECT rank FROM table_24431264_18 WHERE withdrew_due_to = "right wrist surgery" </s>