SELECT a.noakaun, a.namapenyewa, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx >= '2026-01-01' and tarikhtrx < '2026-02-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-12-01' and tarikhtrx < '2026-01-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-11-01' and tarikhtrx < '2025-12-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-08-01' and tarikhtrx < '2025-11-01' GROUP BY noakaun) as jum46, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx >= '2025-02-01' and tarikhtrx < '2025-08-01' GROUP BY noakaun) as jum712, (SELECT sum(baki) FROM transaksi where noakaun = a.noakaun and baki > 0.00 and jenistrx = 'D' and tarikhtrx < '2025-02-01' GROUP BY noakaun) as jumlebih12 FROM penyewa a ORDER BY noakaunTIADA MAKLUMAT TRANSAKSI UNTUK TAHUN INI.