CREATE TABLE table_204_30 (id NUMBER, "year built" CLOB, "works number" NUMBER, "wheel arr." CLOB, "gauge" CLOB, "original owner" CLOB, "name" CLOB, "current location" CLOB, "notes" CLOB)

which works number had a larger gauge , 283 or 317 ?
SELECT "works number" FROM table_204_30 WHERE "works number" IN (283, '317') ORDER BY "gauge" DESC LIMIT 1
SELECT "works number" FROM "table_204_30" WHERE "works number" IN (283, '317') ORDER BY "gauge" DESC FETCH FIRST 1 ROWS ONLY