CREATE TABLE table_202_117 (id NUMBER, "date" CLOB, "ship" CLOB, "nationality" CLOB, "tonnage" NUMBER, "fate" CLOB)

who was sunk the most ?
SELECT "nationality" FROM table_202_117 WHERE "fate" = 'sunk' GROUP BY "nationality" ORDER BY COUNT(*) DESC LIMIT 1
SELECT "nationality" FROM "table_202_117" WHERE "fate" = 'sunk' GROUP BY "nationality" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY