CREATE TABLE table_204_944 (id NUMBER, "mine" CLOB, "province" CLOB, "coordinates" CLOB, "town" CLOB, "dates" CLOB, "comments" CLOB)

which mine was open longer , golden giant or beanland mine ?
SELECT "mine" FROM table_204_944 WHERE "mine" IN ('golden giant mine', 'beanland mine') ORDER BY "dates" - "dates" DESC LIMIT 1
SELECT "mine" FROM "table_204_944" WHERE "mine" IN ('golden giant mine', 'beanland mine') ORDER BY "dates" - "dates" DESC FETCH FIRST 1 ROWS ONLY