Query Komulatif RKPD Program

SELECT
a.skpd,
a.program,
a.id_program,
SUM(a.pagu) as pagu,
COUNT(DISTINCT a.id_renja) as jk,
realisasi_uang,
realisasi_uang / SUM(a.pagu) * 100 as pk,
fisik,
fisik / COUNT(DISTINCT a.id_renja) as pf
FROM tb_renja a
LEFT JOIN(SELECT SUM(realisasi_uang) as realisasi_uang, SUM(fisik) as fisik, id_renja
                     FROM rab
                     GROUP by id_renja)
                     b on a.id_renja = b.id_renja
WHERE a.kode_urusan = '4' AND a.id_skpd = '2'
GROUP BY a.id_program