CREATE TABLE table_10749 ("Date" TEXT, "Name" TEXT, "Flag" TEXT, "Tonnage  ( GRT ) " FLOAT, "Sunk by" TEXT)

Who sunk the ship with the flag of Norway?
SELECT "Sunk by" FROM table_10749 WHERE "Flag" = 'norway'
SELECT "Sunk by" FROM "table_10749" WHERE "Flag" = 'norway'