text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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
  ### Answer:
  SELECT SUM(rank) FROM table_name_90 WHERE bronze < 1 AND gold = 1 AND total < 1