How much money did Crafty Bear wins with a dist of 1 mile?
CREATE TABLE table_name_30 (purse___us$__ VARCHAR, dist VARCHAR, winning_horse VARCHAR)
SELECT purse___us$__ FROM table_name_30 WHERE dist = "1 mile" AND winning_horse = "crafty bear"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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? [/INST] SELECT purse___us$__ FROM table_name_30 WHERE dist = "1 mile" AND winning_horse = "crafty bear" </s>