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_23 (rank INTEGER, gold VARCHAR, total VARCHAR, bronze VARCHAR, silver VARCHAR)
  ### Question:
  What is the lowest Rank with more than 0 bronze, 8 silver, and a total of 19, with less than 9 gold?
  ### Answer:
  SELECT MIN(rank) FROM table_name_23 WHERE bronze > 0 AND silver = 8 AND total = 19 AND gold < 9