user: Question: Which Type has a Date smaller than 1943, and a Builder of ALCO Schenectady, and a Number larger than 822, and Works number of 59867?
Columns: ['Number', 'Builder', 'Type', 'Date', 'Works number']
Types: ['real', 'text', 'text', 'real', 'real']
Sample row: [702.0, 'Baldwin Locomotive Works', '4-6-4', 1930.0, 61371.0]
SQL:

assistant: SELECT "Type" FROM "Table" WHERE "Date" < 1943.0 AND "Builder" = 'ALCO Schenectady' AND "Number" > 822.0 AND "Works number" = 59867.0;