user: ### NOW ANSWER:
Question: How many courses are located in Carmel, Indiana?
Columns: ['Year', 'Player', 'Country', 'Score', 'To par', 'Margin of victory', 'Course', 'Location', 'Purse ( $ )', 'Winners share ($)']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'real', 'real']
Sample row: [2013.0, 'Zach Johnson', 'United States', '64-70-69-65=268', '–16', '2 strokes', 'Conway Farms Golf Club', 'Lake Forest, Illinois', 8000000.0, 1440000.0]
SQL:

assistant: SELECT COUNT("Course") FROM "Table" WHERE "Location" = 'Carmel, Indiana';