What rank has 123 as the total?
CREATE TABLE table_name_96 (rank VARCHAR, total VARCHAR)
SELECT rank FROM table_name_96 WHERE total = 123
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (rank VARCHAR, total VARCHAR) Question: What rank has 123 as the total? [/INST] SELECT rank FROM table_name_96 WHERE total = 123 </s>