user: ### NOW ANSWER:
Question: Name all the date of designations for Kurume
Columns: ['Name', 'Japanese', 'Date of designation', 'Date of reclassification', 'Region', 'Prefecture']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Hakodate', '函館', '2000-11-01', '2005-10-01 ( Core city )', 'Hokkaido', 'Hokkaido']
SQL:

assistant: SELECT "Date of designation" FROM "Table" WHERE "Name" = 'Kurume';