Schema: CREATE TABLE table_name_90 (rank INTEGER, total VARCHAR, bronze VARCHAR, gold VARCHAR)
Question: Name the sum of rank for bronze less than 1 and gold of 1 with total less than 1
SQL: SELECT SUM(rank) FROM table_name_90 WHERE bronze < 1 AND gold = 1 AND total < 1