Realisasi PER PD

SELECT
id_renja,
id_skpd
skpd,
SUM(pagu) as pagu,
realisasi_uang,
realisasi_uang / pagu * 100 as pk,
pf
FROM tb_renja
LEFT JOIN (SELECT id_renja, sum(realisasi_uang) as realisasi_uang,sum(pf) as pf
           FROM rab
           GROUP BY id_renja)
           a USING (id_renja)
GROUP BY id_skpd