CREATE TABLE table_204_100 (id NUMBER, "date" CLOB, "name of ship" CLOB, "nationality" CLOB, "tonnage" NUMBER, "fate" CLOB)

number of boats that were attacked by hans rudolf rosing as a u boat commander
SELECT COUNT("name of ship") FROM table_204_100
SELECT COUNT("name of ship") FROM "table_204_100"