CREATE TABLE table_55742 ("Rank" FLOAT, "Name" CLOB, "Location" CLOB, "Country" CLOB, "Designer ,  Year" CLOB)

Where was the location with Muirfield in Scotland?
SELECT "Location" FROM table_55742 WHERE "Country" = 'scotland' AND "Name" = 'muirfield'
SELECT "Location" FROM "table_55742" WHERE "Country" = 'scotland' AND "Name" = 'muirfield'