DROP TABLE Outcomes; /* Delete table if it already exists */ CREATE TABLE Outcomes ( ship varchar(20), battle varchar(20), result varchar(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');