What are the statuses of the districts whose successor is Wiltshire?
CREATE TABLE "former_districts" (
  "district" text,
  "status" text,
  "date_abolished" text,
  "former_county" text,
  "successor" text
);
SELECT "status" FROM "former_districts" WHERE "successor"='Wiltshire';