SQL JUMLAH TOTAL HAK PER TAHUN DAN PERBULAN

PERBULAN YG GS
------------------------------------------------------
select gsht.thakcod JENIS_HAK,
thak.thakdes JENIS_HAK,
count(*) JUMLAH_HAK,
sum(gssuold.gssuare) JUMLAH_LUAS
from gsht,gssuold,htan,thak
where month(htan.htanboodat)="02"
and year(htan.htanboodat)=2006
and thak.thakcod=gsht.thakcod
and gsht.desaco8=htan.desaco8
and gsht.thakcod=htan.thakcod
and gsht.htanseq=htan.htanseq
and gssuold.desaco8=gsht.desaco8
and gssuold.gssuyea=gsht.gssuyea
and gssuold.gssunum=gsht.gssunum
group by 1,2;

PERBULAN YG SU
--------------------------------------------------------
select paht.thakcod JENIS_HAK,
thak.thakdes JENIS_HAK,
count(*) JUMLAH_HAK,
sum(gssu.gssuare) JUMLAH_LUAS
from paht,gssu,htan,thak
where month(htan.htanboodat)="02"
and thak.thakcod=paht.thakcod
and year(htan.htanboodat)=2006
and paht.desaco8=htan.desaco8
and paht.thakcod=htan.thakcod
and paht.htanseq=htan.htanseq
and gssu.desaco8=paht.desaco8
and gssu.gssuyea=paht.gssuyea
and gssu.gssunum=paht.gssunum
group by 1,2;

PERTAHUN YG GS
--------------------------------------------------------
select gsht.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(*) JUMLAH_HAK,
sum(gssuold.gssuare) JUMLAH_LUAS
from gsht,gssuold,htan,thak
where year(htan.htanboodat)=2006
and thak.thakcod=gsht.thakcod
and gsht.desaco8=htan.desaco8
and gsht.thakcod=htan.thakcod
and gsht.htanseq=htan.htanseq
and gssuold.desaco8=gsht.desaco8
and gssuold.gssuyea=gsht.gssuyea
and gssuold.gssunum=gsht.gssunum
group by 1,2;

PERTAHUN YG SU
--------------------------------------------------------
select paht.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(*) JUMLAH_HAK,
sum(gssu.gssuare) JUMLAH_LUAS
from paht,gssu,htan,thak
where year(htan.htanboodat)=2006
and thak.thakcod=paht.thakcod
and paht.desaco8=htan.desaco8
and paht.thakcod=htan.thakcod
and paht.htanseq=htan.htanseq
and gssu.desaco8=paht.desaco8
and gssu.gssuyea=paht.gssuyea
and gssu.gssunum=paht.gssunum
group by 1,2;