user: ### NOW ANSWER:
Question: What year did the Caphouse Colliery railway close?
Columns: ['Name', 'Opened', 'Closed', 'Length', 'Location']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Campbeltown and Machrihanish Light Railway', '1877', '1932', 'miles (km)', 'Mull of Kintyre , Scotland']
SQL:

assistant: SELECT "Closed" FROM "Table" WHERE "Name" = 'Caphouse Colliery';