DROP TABLE Product; 
/* Delete table if it already exists */

CREATE TABLE Product (
  id int,
  maker varchar(1),
  model varchar(4),
  type varchar(10)
);

INSERT INTO Product VALUES (1,'A', '1001', 'pc');
INSERT INTO Product VALUES (2,'A', '1002', 'pc');
INSERT INTO Product VALUES (3,'A', '1003', 'pc');
INSERT INTO Product VALUES (4,'A', '2004', 'laptop');
INSERT INTO Product VALUES (5,'A', '2005', 'laptop');
INSERT INTO Product VALUES (6,'A', '2006', 'laptop');
INSERT INTO Product VALUES (7,'B', '1004', 'pc');
INSERT INTO Product VALUES (8,'B', '1005', 'pc');
INSERT INTO Product VALUES (9,'B', '1006', 'pc');
INSERT INTO Product VALUES (10,'B', '2001', 'laptop');
INSERT INTO Product VALUES (11,'B', '2002', 'laptop');
INSERT INTO Product VALUES (12,'B', '2003', 'laptop');
INSERT INTO Product VALUES (13,'C', '1007', 'pc');
INSERT INTO Product VALUES (14,'C', '1008', 'pc');
INSERT INTO Product VALUES (15,'C', '2008', 'laptop');
INSERT INTO Product VALUES (16,'C', '2009', 'laptop');
INSERT INTO Product VALUES (17,'C', '3002', 'printer');
INSERT INTO Product VALUES (18,'C', '3003', 'printer');
INSERT INTO Product VALUES (19,'C', '3006', 'printer');
INSERT INTO Product VALUES (20,'D', '1009', 'pc');
INSERT INTO Product VALUES (21,'D', '1010', 'pc');
INSERT INTO Product VALUES (22,'D', '1011', 'pc');
INSERT INTO Product VALUES (23,'D', '2007', 'laptop');
INSERT INTO Product VALUES (24,'E', '1012', 'pc');
INSERT INTO Product VALUES (25,'E', '1013', 'pc');
INSERT INTO Product VALUES (26,'E', '2010', 'laptop');
INSERT INTO Product VALUES (27,'F', '3001', 'printer');
INSERT INTO Product VALUES (28,'F', '3004', 'printer');
INSERT INTO Product VALUES (29,'G', '3005', 'printer');
INSERT INTO Product VALUES (30,'H', '3007', 'printer');