CREATE TABLE Outcomes ( ship char(20), battle char(20), result char(10) ); INSERT INTO Outcomes VALUES ('Bismarck','North Atlantic','sunk'); INSERT INTO Outcomes VALUES ('California','Suriago Strait','ok'); INSERT INTO Outcomes VALUES ('Duke of York','North Cape','ok'); INSERT INTO Outcomes VALUES ('Fuso','Suriago Strait','sunk'); INSERT INTO Outcomes VALUES ('Hood','North Atlantic','sunk'); INSERT INTO Outcomes VALUES ('King George V','North Atlantic','ok'); INSERT INTO Outcomes VALUES ('Kirishima','Guadalcanal','sunk'); INSERT INTO Outcomes VALUES ('Prince of Wales','North Atlantic','damaged'); INSERT INTO Outcomes VALUES ('Rodney','North Atlantic','ok'); INSERT INTO Outcomes VALUES ('Scharnhorst','North Cape','sunk'); INSERT INTO Outcomes VALUES ('South Dakota','Guadalcanal','damaged'); INSERT INTO Outcomes VALUES ('Tennessee','Suriago Strait','ok'); INSERT INTO Outcomes VALUES ('Washington','Guadalcanal','ok'); INSERT INTO Outcomes VALUES ('West Virginia','Suriago Strait','ok'); INSERT INTO Outcomes VALUES ('Yamashiro','Suriago Strait','sunk');