CREATE TABLE table_9859 ("Date" CLOB, "Name" CLOB, "Nationality" CLOB, "Tonnage  ( GRT ) " FLOAT, "Fate" CLOB)

How much tonnage was damaged?
SELECT SUM("Tonnage (GRT)") FROM table_9859 WHERE "Fate" = 'damaged'
SELECT SUM("Tonnage (GRT)") FROM "table_9859" WHERE "Fate" = 'damaged'