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