CREATE TABLE table_name_74 (county VARCHAR, location VARCHAR)

Which County has a Location of edinburgh?
SELECT county FROM table_name_74 WHERE location = "edinburgh"
SELECT "county" FROM "table_name_74" WHERE "edinburgh" = "location"