CREATE TABLE table_17176 ("Name of ground" CLOB, "Location" CLOB, "Year" CLOB, "FC matches" FLOAT, "LA matches" FLOAT, "T20 matches" FLOAT, "Total" FLOAT)

Where is ropery lane located?
SELECT "Location" FROM table_17176 WHERE "Name of ground" = 'Ropery Lane'
SELECT "Location" FROM "table_17176" WHERE "Name of ground" = 'Ropery Lane'