SELECT a.noakaun, a.namapenyewa, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx >= '2026-12-01' GROUP BY noakaun) as jum0, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx >= '2026-11-01' and tarikhtrx < '2026-12-01' GROUP BY noakaun) as jum1, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx >= '2026-10-01' and tarikhtrx < '2026-11-01' GROUP BY noakaun) as jum2, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx >= '2026-9-01' and tarikhtrx < '2026-10-01' GROUP BY noakaun) as jum3, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx >= '2026-8-01' and tarikhtrx < '2026-9-01' GROUP BY noakaun) as jum4, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx >= '2026-7-01' and tarikhtrx < '2026-8-01' GROUP BY noakaun) as jum5, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx >= '2026-6-01' and tarikhtrx < '2026-7-01' GROUP BY noakaun) as jum6, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx >= '2025-12-01' and tarikhtrx < '2026-6-01' GROUP BY noakaun) as jum712, (SELECT sum(amaun) FROM transaksi where noakaun = a.noakaun and jenistrx = 'C' and tarikhtrx < '2025-12-01' GROUP BY noakaun) as jumlebih12 FROM penyewa a ORDER BY a.noakaun ASC LIMIT 0,10TIADA MAKLUMAT TRANSAKSI UNTUK TAHUN INI.