CREATE TABLE table_30218 ("District" CLOB, "Status" CLOB, "Date abolished" CLOB, "Former county" CLOB, "Successor" CLOB)

What are the statuses of the districts whose successor is Wiltshire?
SELECT "Status" FROM table_30218 WHERE "Successor" = 'Wiltshire'
SELECT "Status" FROM "table_30218" WHERE "Successor" = 'Wiltshire'