CREATE TABLE PC (
  model char(4),
  speed int,
  ram int,
  hd int,
  rd char(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);
