List the rank of the player that left the tournament due to right foot injury
CREATE TABLE table_24431264_18 (rank VARCHAR, withdrew_due_to VARCHAR)
SELECT COUNT(rank) FROM table_24431264_18 WHERE withdrew_due_to = "right foot injury"
<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 the tournament due to right foot injury [/INST] SELECT COUNT(rank) FROM table_24431264_18 WHERE withdrew_due_to = "right foot injury" </s>