SELECT noakaun, sum(baki)
FROM transaksi
WHERE baki >0
AND tarikhtrx > '2006-12-01'
and tarikhtrx < '2007-11-01'
group by noakaun
LIMIT 0 , 30

SELECT a.noakaun, a.namapenyewa, (

SELECT sum( baki )
FROM transaksi
WHERE baki >0
AND tarikhtrx < '2007-12-01'
AND tarikhtrx >= '2007-11-01'
AND noakaun = a.noakaun
GROUP BY noakaun
) AS jum1, (

SELECT sum( baki )
FROM transaksi
WHERE baki >0
AND tarikhtrx < '2007-11-01'
AND tarikhtrx >= '2007-09-01'
AND noakaun = a.noakaun
GROUP BY noakaun
) AS jum23, (

SELECT sum( baki )
FROM transaksi
WHERE baki >0
AND tarikhtrx < '2007-09-01'
AND tarikhtrx >= '2007-06-01'
AND noakaun = a.noakaun
GROUP BY noakaun
) AS jum46, (

SELECT sum( baki )
FROM transaksi
WHERE baki >0
AND tarikhtrx < '2007-06-01'
AND tarikhtrx >= '2006-12-01'
AND noakaun = a.noakaun
GROUP BY noakaun
) AS jum712, (

SELECT sum( baki )
FROM transaksi
WHERE baki >0
AND tarikhtrx < '2006-12-01'
AND noakaun = a.noakaun
GROUP BY noakaun
) AS jumlebih12
FROM penyewa a
ORDER BY noakaun