CREATE TABLE table_1176371_1 (location VARCHAR, name_of_ground VARCHAR)

Where is ropery lane located?
SELECT location FROM table_1176371_1 WHERE name_of_ground = "Ropery Lane"
SELECT "location" FROM "table_1176371_1" WHERE "Ropery Lane" = "name_of_ground"