CREATE TABLE table_name_46 (type VARCHAR, works_number VARCHAR, number VARCHAR, date VARCHAR, builder VARCHAR)

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?
SELECT type FROM table_name_46 WHERE date < 1943 AND builder = "alco schenectady" AND number > 822 AND works_number = 59867
SELECT "type" FROM "table_name_46" WHERE "alco schenectady" = "builder" AND "date" < 1943 AND "number" > 822 AND "works_number" = 59867