CREATE TABLE table_203_268 (id NUMBER, "date" CLOB, "name" CLOB, "nationality" CLOB, "tonnage\ ( grt ) " NUMBER, "fate" CLOB)

how many submarines were sunk ?
SELECT COUNT("name") FROM table_203_268 WHERE "fate" = 'sunk'
SELECT COUNT("name") FROM "table_203_268" WHERE "fate" = 'sunk'