text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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?
  ### Answer:
  SELECT type FROM table_name_46 WHERE date < 1943 AND builder = "alco schenectady" AND number > 822 AND works_number = 59867