/* 
 * 
 *
 * 
 */

create table workson1 (
        essn               char(9)            not null,
        pno                int                not null,
    primary key (essn, pno)
) ;


insert into workson1
(essn, pno)
values
('100000001', 1),
('100000002', 1),
('100000003', 1),
('100000004', 45),
('100000005', 45),
('100000005', 56),
('100000006', 56),
('100000006', 67),
('100000007', 67),
('100000007', 78),
('100000008', 78),
('100000008', 89),
('100000009', 89),
('100000004', 410),
('100000010', 410),
('100000010', 1110),
('100000011', 1110),
('100000011', 1112),
('100000012', 1112),
('100000012', 129),
('100000009', 129),
('100000014', 30),
('100000015', 30);