CREATE TABLE table_name_46 (type VARCHAR(255), works_number VARCHAR(255), number VARCHAR(255), date VARCHAR(255), builder VARCHAR(255))
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?
    
SQL: SELECT type FROM table_name_46 WHERE date < 1943 AND builder = "alco schenectady" AND number > 822 AND works_number = 59867