CREATE TABLE table_name_4 (location VARCHAR, country VARCHAR, name VARCHAR)

Where was the location with Muirfield in Scotland?
SELECT location FROM table_name_4 WHERE country = "scotland" AND name = "muirfield"
SELECT "location" FROM "table_name_4" WHERE "country" = "scotland" AND "muirfield" = "name"