DROP TABLE PC; /* Delete table if it already exists */ CREATE TABLE PC ( model varchar(4), speed int, ram int, hd int, rd varchar(10), price int ); INSERT INTO PC VALUES ('1001', 700, 64, 10, '48xCD', 799); INSERT INTO PC VALUES ('1002', 1500, 128, 60, '12xDVD', 2499); INSERT INTO PC VALUES ('1003', 866, 128, 20, '8xDVD', 1999); INSERT INTO PC VALUES ('1004', 866, 64, 10, '12xDVD', 999); INSERT INTO PC VALUES ('1005', 1000, 128, 20, '12xDVD', 1499); INSERT INTO PC VALUES ('1006', 1300, 256, 40, '16xDVD', 2119); INSERT INTO PC VALUES ('1007', 1400, 128, 80, '12xDVD', 2299); INSERT INTO PC VALUES ('1008', 700, 64, 30, '24xCD', 999); INSERT INTO PC VALUES ('1009', 1200, 128, 80, '16xDVD', 1699); INSERT INTO PC VALUES ('1010', 750, 64, 30, '40xCD', 699); INSERT INTO PC VALUES ('1011', 1100, 128, 60, '16xDVD', 1299); INSERT INTO PC VALUES ('1012', 350, 64, 7, '48xCD', 799); INSERT INTO PC VALUES ('1013', 733, 256, 60, '12xDVD', 2499);