CREATE TABLE table_name_8 (vehicle VARCHAR2, class VARCHAR2)

Which vehicle had a class of CM14?
SELECT vehicle FROM table_name_8 WHERE class = "cm14"
SELECT "vehicle" FROM "table_name_8" WHERE "class" = "cm14"