user: ### NOW ANSWER:
Question: Which post had the horse named Chocolate Candy?
Columns: ['Post', 'Horse name', 'Trainer', 'Jockey', 'Opening Odds', 'Starting Odds', 'Finishing Pos.']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'real']
Sample row: [1.0, 'Chocolate Candy', 'Jerry Hollendorfer', 'Garrett Gomez', '10-1', '9.50', 9.0]
SQL:

assistant: SELECT "Post" FROM "Table" WHERE "Horse name" = 'Chocolate Candy';