DROP TABLE Classes; /* Delete table if it already exists */ CREATE TABLE Classes ( class varchar(20), type varchar(2), country varchar(20), numGuns int, bore int, displacement int ); INSERT INTO Classes VALUES ('Bismarck','bb','Germany',8,15,42000); INSERT INTO Classes VALUES ('Iowa','bb','USA',9,16,46000); INSERT INTO Classes VALUES ('Kongo','bc','Japan',8,14,32000); INSERT INTO Classes VALUES ('North Carolina','bb','USA',9,16,37000); INSERT INTO Classes VALUES ('Renown','bc','Gt. Britain',6,15,32000); INSERT INTO Classes VALUES ('Revenge','bb','Gt. Britain',8,15,29000); INSERT INTO Classes VALUES ('Tennessee','bb','USA',12,14,32000); INSERT INTO Classes VALUES ('Yamato','bb','Japan',9,18,65000);