Persentase Masalah

Salah Query
SELECT a.*,COUNT(km.IdKegiatanMonev) AS Jumlah FROM tbl_kategori_masalah a LEFT OUTER JOIN (tbl_monev_kegiatan km, tbl_monev_program b) ON km.IdKategoriMasalahTw4=a.IdKategoriMasalah AND km.IdProgramMonev=b.IdProgramMonev AND b.Tahun=2020 AND ( (b.IdKantor=1 AND b.IdInstansi IN (SELECT IdSkpd FROM tbl_skpd_aktif WHERE Tahun=2020)) OR (b.IdKantor=2 AND b.IdInstansi IN (SELECT IdKecamatan FROM tbl_kecamatan_aktif WHERE Tahun=2020)) OR (b.IdKantor=3 AND b.IdInstansi IN (SELECT IdKelurahan FROM tbl_kelurahan_aktif WHERE Tahun=2020)) ) GROUP BY a.IdKategoriMasalah ORDER BY