CREATE table customer
(
cno int,
cname varchar(20),
phonenumber int,
type varchar(3)
)
INSERT INTO customer VALUES(1,'AAA',1234,'P')
INSERT INTO customer VALUES (1,'AAA',3456,'W')
INSERT INTO customer VALUES (1,'AAA',3456,'H')

INSERT INTO customer VALUES(2,'BBB',5678,'W')
INSERT INTO customer VALUES (2,'BBB',7894,'H')

INSERT INTO customer VALUES(3,'CCC',1111,'P')
INSERT INTO customer VALUES (3,'CCC',2222,'H')

INSERT INTO customer VALUES (4,'DDD',8888,'H')


SELECT * FROM customer