Sql Jumlah BPHTB Per-Tahun & Per-Bulan

JUMLAH NILAI BPHTB PERTAHUN
----------------------------------------------------
select year(aktadat),
sum(aktaceimgg)
from akta
where aktaceimgg is not null
and aktaceimgg>0
and indecod<>0
and indecod>0
group by 1;

JUMLAH NILAI BPHTB PERBULAN
----------------------------------------------------
select month(aktadat),
sum(aktaceimgg)
from akta
where aktaceimgg is not null
and aktaceimgg>0
and indecod<>0
and indecod>0
and year(aktadat)=2005
group by 1;

JUMLAH NILAI BPHTB DAN TOTAL BIDANG
----------------------------------------------------
select year(akta.aktadat) PERTAHUN_AKTA,
sum(akta.aktaceimgg) JUMLAH_BPHTB,
count(distinct inde.masterpk3) JUMLAH_BIDANG
from akta,inde
where akta.aktaceimgg is not null
and akta.aktaceimgg>0
and akta.indecod<>0
and akta.indecod>0
and inde.tindcod<>"06"
and inde.indecod=akta.indecod
group by 1;

-----------------------------------------------------

ANALISA
-----------------------
select akta.aktadat,
akta.aktaceimgg,
akta.aktavalue,
inde.expeid,
inde.tindcod,
expe.expecod,
expe.expeyea,
expe.stexcod
from akta,inde,expe
where akta.aktaceimgg is not null
and akta.aktaceimgg>0
and akta.indecod<>0
and akta.indecod>0
and expe.stexcod="OP"
and inde.tindcod<>"06"
and inde.indecod=akta.indecod
and expe.expeid=inde.expeid;