LSPR - QUERY CEK PIUTANG

select
  a.IDMAHASISWA,
  a.IDKOMPONEN,
  a.TAGIHAN,
  COALESCE(SUM(b.BAYAR), 0) AS "Total Pembayaran",
  CASE 
        WHEN COALESCE(SUM(b.BAYAR), 0) >= a.TAGIHAN THEN 'LUNAS'
        ELSE 'BELUM LUNAS'
    END AS status_pembayaran
from
  biayatagihan a
  join bayartagihan_detil b on a.IDMAHASISWA = b.IDMAHASISWA
  and a.TAHUN = b.TAHUN
  and a.SEMESTER = b.SEMESTER
  and a.IDKOMPONEN = b.IDKOMPONEN
  join bayartagihan c on b.TANGGAL = c.TANGGAL
  and b.IDMAHASISWA = c.IDMAHASISWA
  and c.STATUS = '1'
where
  a.TAHUN = '2025'
  and a.semester = '2'
  and a.IDKOMPONEN in ('LSPS1', 'TF')
group by a.IDMAHASISWA, a.IDKOMPONEN, a.TAHUN, a.SEMESTER, a.BIAYA
HAVING COALESCE(SUM(b.BAYAR), 0) >= a.TAGIHAN