CREATE TABLE table_58897 ("Class" CLOB, "Number ( s ) " CLOB, "Quantity" FLOAT, "Year ( s )  of Manufacture" CLOB, "Type" CLOB)

Which class has fewer than 10 and number(s) names?
SELECT "Class" FROM table_58897 WHERE "Quantity" < '10' AND "Number(s)" = 'names'
SELECT "Class" FROM "table_58897" WHERE "Number(s)" = 'names' AND "Quantity" < '10'