DROP TABLE Ships; /* Delete table if it already exists */ CREATE TABLE Ships ( name varchar(20), class varchar(20), launched int ); INSERT INTO Ships VALUES ('California','Tennessee',1921); INSERT INTO Ships VALUES ('Haruna','Kongo',1915); INSERT INTO Ships VALUES ('Hiei','Kongo',1914); INSERT INTO Ships VALUES ('Iowa','Iowa',1943); INSERT INTO Ships VALUES ('Kirishima','Kongo',1915); INSERT INTO Ships VALUES ('Kongo','Kongo',1913); INSERT INTO Ships VALUES ('Missouri','Iowa',1944); INSERT INTO Ships VALUES ('Musashi','Yamato',1942); INSERT INTO Ships VALUES ('New Jersey','Iowa',1943); INSERT INTO Ships VALUES ('North Carolina','North Carolina',1941); INSERT INTO Ships VALUES ('Ramillies','Revenge',1917); INSERT INTO Ships VALUES ('Renown','Renown',1916); INSERT INTO Ships VALUES ('Repulse','Renown',1916); INSERT INTO Ships VALUES ('Resolution','Revenge',1916); INSERT INTO Ships VALUES ('Revenge','Revenge',1916); INSERT INTO Ships VALUES ('Royal Oak','Revenge',1916); INSERT INTO Ships VALUES ('Royal Sovereign','Revenge',1916); INSERT INTO Ships VALUES ('Tennessee','Tennessee',1920); INSERT INTO Ships VALUES ('Washington','North Carolina',1941); INSERT INTO Ships VALUES ('Wisconsin','Iowa',1944); INSERT INTO Ships VALUES ('Yamato','Yamato',1941);