user: ### NOW ANSWER:
Question: What is the Status of Mexborough?
Columns: ['Name', 'Status', 'Population', 'District', 'Former local authority']
Types: ['text', 'text', 'real', 'text', 'text']
Sample row: ['Barnsley', 'Unparished area', 65188.0, 'Barnsley', 'Barnsley County Borough']
SQL:

assistant: SELECT "Status" FROM "Table" WHERE "Name" = 'Mexborough';