CREATE TABLE table_name_69 (works_no VARCHAR, class VARCHAR, year VARCHAR)

Which works number has a class of 15th and year of 1940?
SELECT works_no FROM table_name_69 WHERE class = "15th" AND year = "1940"
SELECT "works_no" FROM "table_name_69" WHERE "15th" = "class" AND "1940" = "year"