Schema: CREATE TABLE table_name_96 (rank VARCHAR, total VARCHAR)
Question: What rank has 123 as the total?
SQL: SELECT rank FROM table_name_96 WHERE total = 123