Table 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