Table: golf_courses_2
Columns: rank
name
location
country
designer_year

Question: Where was the location with Muirfield in Scotland?
SQL: SELECT "location" FROM golf_courses_2 WHERE "country" = 'scotland' AND "name" = 'muirfield'