Which Took Office that has a Party of democrat, under the name of John Hancock
CREATE TABLE "list_of_representatives" (
  "name" text,
  "took_office" text,
  "left_office" text,
  "party" text,
  "district_residence" text
);
SELECT "took_office" FROM "list_of_representatives" WHERE "party"='democrat' AND "name"='john hancock';