/* 
 * 
 *
 * 
 */

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


insert into workson2
(essn, pno)
values
('100000001', 1),   -- first group
('100000002', 1),
('100000003', 1),
('100000004', 1),

('100000005', 2),
('100000006', 2),
('100000007', 2),
('100000008', 2),

('100000010', 3),
('100000011', 3),
('100000012', 3),
('100000013', 3),

('100000020', 120),
('100000001', 120),
('100000021', 2021),
('100000020', 2021),
('100000021', 2122),
('100000022', 2122),
('100000022', 2322),
('100000023', 2322),
('100000023', 2324),
('100000024', 2324),
('100000024', 324),
('100000012', 324);