create table paytran1
(idno varchar2(4),
projid varchar2(3),
hourswk number(4,2));
insert into paytran1
values(1111,123,20);
insert into paytran1
values(1111,456,10);
insert into paytran1
values(1111,789,15);
insert into paytran1
values(2222,123,17);
insert into paytran1
values(2222,456,24);
insert into paytran1
values(2222,789,20);
insert into paytran1
values(3333,123,20);
insert into paytran1
values(3333,789,20);
insert into paytran1
values(4444,123,10);
insert into paytran1
values(4444,456,28);
insert into paytran1
values(4444,789,5);
insert into paytran1
values(5555,456,40);
insert into paytran1
values(6666,456,44);
insert into paytran1
values(7777,456,30);
insert into paytran1
values(7777,789,15);
insert into paytran1
values(8888,123,10);
insert into paytran1
values(8888,456,25);
insert into paytran1
values(8888,789,5);