SELECT NAMA_GRUP, SUM(TOTAL_KPI_PROGRAM)/COUNT(ctr.TANGGAL) AS AVG_KPI, COUNT(ctr.TANGGAL) AS JUMLAH_TANGGAL, ctr.TANGGAL AS TANGGAL
FROM ckm_t_grup ctg, ckm_t_program ctp, ckm_t_rundown ctr, ckm_t_calculate ctcWHERE ctg.ID_GRUP = ctp.ID_GRUP AND ctp.ID_PROGR