CREATE TABLE Product (
  maker char(1),
  model char(4),
  type char(10)
);

INSERT INTO Product VALUES ('A', '1001', 'pc');
INSERT INTO Product VALUES ('A', '1002', 'pc');
INSERT INTO Product VALUES ('A', '1003', 'pc');
INSERT INTO Product VALUES ('A', '2004', 'laptop');
INSERT INTO Product VALUES ('A', '2005', 'laptop');
INSERT INTO Product VALUES ('A', '2006', 'laptop');
INSERT INTO Product VALUES ('B', '1004', 'pc');
INSERT INTO Product VALUES ('B', '1005', 'pc');
INSERT INTO Product VALUES ('B', '1006', 'pc');
INSERT INTO Product VALUES ('B', '2001', 'laptop');
INSERT INTO Product VALUES ('B', '2002', 'laptop');
INSERT INTO Product VALUES ('B', '2003', 'laptop');
INSERT INTO Product VALUES ('C', '1007', 'pc');
INSERT INTO Product VALUES ('C', '1008', 'pc');
INSERT INTO Product VALUES ('C', '2008', 'laptop');
INSERT INTO Product VALUES ('C', '2009', 'laptop');
INSERT INTO Product VALUES ('C', '3002', 'printer');
INSERT INTO Product VALUES ('C', '3003', 'printer');
INSERT INTO Product VALUES ('C', '3006', 'printer');
INSERT INTO Product VALUES ('D', '1009', 'pc');
INSERT INTO Product VALUES ('D', '1010', 'pc');
INSERT INTO Product VALUES ('D', '1011', 'pc');
INSERT INTO Product VALUES ('D', '2007', 'laptop');
INSERT INTO Product VALUES ('E', '1012', 'pc');
INSERT INTO Product VALUES ('E', '1013', 'pc');
INSERT INTO Product VALUES ('E', '2010', 'laptop');
INSERT INTO Product VALUES ('F', '3001', 'printer');
INSERT INTO Product VALUES ('F', '3004', 'printer');
INSERT INTO Product VALUES ('G', '3005', 'printer');
INSERT INTO Product VALUES ('H', '3007', 'printer');
