Table: pga_tour_bmw_championship
Columns: year
player
country
score
to_par
margin_of_victory
course
location
purse
winners_share

Question: What was the margin of victory for the event in lake forest, illinois?
SQL: SELECT "margin_of_victory" FROM pga_tour_bmw_championship WHERE "location" = 'Lake Forest, Illinois'

Question: What was zach johnson's score to par?
SQL: SELECT "to_par" FROM pga_tour_bmw_championship WHERE "player" = 'Zach Johnson'

Question: What was the winning score at bellerive country club?
SQL: SELECT "score" FROM pga_tour_bmw_championship WHERE "course" = 'Bellerive Country Club'

Question: How many courses are located in carmel, indiana?
SQL: SELECT COUNT("course") FROM pga_tour_bmw_championship WHERE "location" = 'Carmel, Indiana'