CREATE TABLE table_41580 ("Name" CLOB, "Japanese" CLOB, "Date of designation" CLOB, "Date of reclassification" CLOB, "Region" CLOB, "Prefecture" CLOB)

Which Date of designation has a Name of kurume?
SELECT "Date of designation" FROM table_41580 WHERE "Name" = 'kurume'
SELECT "Date of designation" FROM "table_41580" WHERE "Name" = 'kurume'