Q#1 : select f.ppno, f.subpp, sum(s.quantity) DQTY
from sub_fabric_delivered s, fabric_delivered f
where s.fdno = f.fdno
group by f.ppno, f.subpp

Q#2: select p.ppno, p.subpp, sum(sp.req_kgs) RQTY
from sub_program sp, program p
where sp.jobno=p.jobno
group by p.ppno, p.subpp

SELECT f.ppno, f.subpp, p.item, sum(sp.req_kgs) RKGS,SUM (s.quantity) qty, s.fdno
FROM sub_fabric_delivered s, fabric_delivered f, program p,
sub_program sp
WHERE s.fdno = f.fdno
AND sp.jobno = p.jobno
AND f.ppno = p.ppno
and s.color = sp.color
GROUP BY s.fdno,sp.req_kgs, f.ppno, f.subpp, p.item
ORDER BY f.ppno,f.subpp;