SELECT a.noakaun, a.namapenyewa, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx >= '2025-11-01' and tarikhtrx < '2025-12-01' GROUP BY noakaun) as jum1, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx >= '2025-10-01' and tarikhtrx < '2025-11-01' GROUP BY noakaun) as jum2, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx >= '2025-09-01' and tarikhtrx < '2025-10-01' GROUP BY noakaun) as jum3, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx >= '2025-06-01' and tarikhtrx < '2025-09-01' GROUP BY noakaun) as jum46, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx >= '2024-12-01' and tarikhtrx < '2025-06-01' GROUP BY noakaun) as jum712, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx < '2024-12-01' GROUP BY noakaun) as jumlebih12 FROM penyewa a ORDER BY noakaunTIADA MAKLUMAT TRANSAKSI UNTUK TAHUN INI.