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_30 (purse___us$__ VARCHAR, dist VARCHAR, winning_horse VARCHAR)
  ### Question:
  How much money did Crafty Bear wins with a dist of 1 mile?
  ### Answer:
  SELECT purse___us$__ FROM table_name_30 WHERE dist = "1 mile" AND winning_horse = "crafty bear"