CREATE TABLE table_204_125 (id NUMBER, "state" CLOB, "type" CLOB, "name" CLOB, "title" CLOB, "royal house" CLOB, "from" CLOB, "to" CLOB)

who ruled longer , zhao or zhaoxiang ?
SELECT "name" FROM table_204_125 WHERE "name" IN ('zhao', 'zhaoxiang') ORDER BY "from" - "to" DESC LIMIT 1
SELECT "name" FROM "table_204_125" WHERE "name" IN ('zhao', 'zhaoxiang') ORDER BY "from" - "to" DESC FETCH FIRST 1 ROWS ONLY