user: Question: for type Diesel-Mechanical and configuration B-B, what is the status?
Columns: ['Name', 'Livery', 'Arrival', 'Type', 'Configuration', 'Builder', 'Built', 'Status', 'Location']
Types: ['text', 'text', 'real', 'text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['River Irt', 'Mid Green', 1917.0, 'Steam', '0-8-2', 'Sir Arthur Heywood', 1894.0, 'Under overhaul', 'Workington']
SQL:

assistant: SELECT "Status" FROM "Table" WHERE "Configuration" = 'B-B' AND "Type" = 'Diesel-Mechanical';