Which venues were closed because they were replaced?
CREATE TABLE "defunct" (
  "venue" text,
  "location" text,
  "environment" text,
  "closed" text,
  "reason" text
);
SELECT "location" FROM "defunct" WHERE "reason"='replaced';