CREATE TABLE table_204_850 (id NUMBER, "name" CLOB, "railway" CLOB, "series" CLOB, "maker" CLOB, "dates" CLOB, "drive" CLOB, "wheel arrangement" CLOB, "weight" CLOB, "power" CLOB, "notes" CLOB)

does the ae 8/8 weigh more or less than the re 6/6 ?
SELECT (SELECT "weight" FROM table_204_850 WHERE "name" = 'ae 8/8') > (SELECT "weight" FROM table_204_850 WHERE "name" = 're 6/6')
SELECT (SELECT "weight" FROM "table_204_850" WHERE "name" = 'ae 8/8') > (SELECT "weight" FROM "table_204_850" WHERE "name" = 're 6/6')