Name thenames for 2002-04-01
CREATE TABLE "former_special_cities_now_core_or_design" (
  "name" text,
  "japanese" text,
  "date_of_designation" text,
  "date_of_reclassification" text,
  "region" text,
  "prefecture" text
);
SELECT "name" FROM "former_special_cities_now_core_or_design" WHERE "date_of_designation"='2002-04-01';