Table: us_amateur_golf_champs
Columns: year
edition
course
location
dates

Question: What was the course called that had an Edition of 117th?
SQL: SELECT "course" FROM us_amateur_golf_champs WHERE "edition" = '117th'

Question: What was the earliest year that had a location of Brookline, Massachusetts?
SQL: SELECT MIN("year") FROM us_amateur_golf_champs WHERE "location" = 'brookline, massachusetts'

Question: What year had an edition of 115th?
SQL: SELECT AVG("year") FROM us_amateur_golf_champs WHERE "edition" = '115th'