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

which king ruled the longest ?
SELECT "name" FROM table_204_125 ORDER BY "from" - "to" DESC LIMIT 1
SELECT "name" FROM "table_204_125" ORDER BY "from" - "to" DESC FETCH FIRST 1 ROWS ONLY