user: ### NOW ANSWER:
Question: What are the statuses of the districts whose successor is Wiltshire?
Columns: ['District', 'Status', 'Date abolished', 'Former county', 'Successor']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Alnwick', 'non-metropolitan district', '1 April 2009', 'Northumberland', 'Northumberland']
SQL:

assistant: SELECT "Status" FROM "Table" WHERE "Successor" = 'Wiltshire';