user: ### NOW ANSWER:
Question: how many Curtiss XBTC aircraft are retired?
Columns: ['Aircraft type', 'National Origin', '1st Flight', 'In Service', 'Retired', '# built']
Types: ['text', 'text', 'real', 'text', 'text', 'text']
Sample row: ['Aichi B7A', 'Japan', 1942.0, '1944', '1945', '114']
SQL:

assistant: SELECT COUNT("Retired") FROM "Table" WHERE "Aircraft type" = 'Curtiss XBTC';