CREATE TABLE table_name_23 (class VARCHAR2, type VARCHAR2)

What is the class of the locomotive with a 0-4-0st type?
SELECT class FROM table_name_23 WHERE type = "0-4-0st"
SELECT "class" FROM "table_name_23" WHERE "0-4-0st" = "type"