Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

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

### 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?

### Accurate SQL ###

SELECT type FROM table_name_46 WHERE date < 1943 AND builder = "alco schenectady" AND number > 822 AND works_number = 59867