CREATE TABLE table_name_30 (purse___us$__ VARCHAR2, dist VARCHAR2, winning_horse VARCHAR2)

How much money did Crafty Bear wins with a dist of 1 mile?
SELECT purse___us$__ FROM table_name_30 WHERE dist = "1 mile" AND winning_horse = "crafty bear"
SELECT "purse___us$__" FROM "table_name_30" WHERE "1 mile" = "dist" AND "crafty bear" = "winning_horse"