CREATE TABLE table_name_36 (date_of_designation VARCHAR, name VARCHAR)

Which Date of designation has a Name of kurume?
SELECT date_of_designation FROM table_name_36 WHERE name = "kurume"
SELECT "date_of_designation" FROM "table_name_36" WHERE "kurume" = "name"