SQL Nilai HT per bulan per PPAT

Perbulan per nama PPAT
select month(inde.indeanodat) BULAN,
sum(akta.aktaceimgg) Nilai_HT,
govp.govpnam Nama_PPAT
from akta,inde,govp
where akta.indecod=inde.indecod
and inde.masterpk1="2004"
and inde.indetyp="R"
and inde.tdoccod="B6"
and month(akta.aktadat)=month(inde.indeanodat)
and govp.govpcod=akta.govpcod
group by 1,3;

Perbulan
select month(inde.indeanodat) BULAN,
sum(akta.aktaceimgg) Nilai_HT
from akta,inde
where akta.indecod=inde.indecod
and inde.masterpk1="2004"
and inde.indetyp="R"
and inde.tdoccod="B6"
and month(akta.aktadat)=month(inde.indeanodat)
group by 1;

Pertahun
select sum(akta.aktaceimgg) from akta,inde
where akta.indecod=inde.indecod
and inde.masterpk1="2005"
and inde.indetyp="R"
and inde.tdoccod="B6";