user: ### NOW ANSWER:
Question: Where was the location with Muirfield in Scotland?
Columns: ['Rank', 'Name', 'Location', 'Country', 'Designer, Year']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'Pine Valley', 'Pine Valley', 'United States', 'George Crump / Harry Colt , 1918']
SQL:

assistant: SELECT "Location" FROM "Table" WHERE "Country" = 'Scotland' AND "Name" = 'Muirfield';