TOTAL HAK DARI HTAN

TOTAL HAK YG SUDAH TERBIT
--------------------------------
select htan.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(distinct htan.htanseq) JUMLAH_HAK
from htan,thak
where thak.thakcod=htan.thakcod
group by 1,2;

TOTAL HAK MASIH AKTIF
--------------------------------
select htan.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(distinct htan.htanseq) JUMLAH_HAK
from htan,thak
where thak.thakcod=htan.thakcod
and htan.htanflgact="Y"
group by 1,2;

TOTAL HAK SUDAH MATI
--------------------------------
select htan.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(distinct htan.htanseq) JUMLAH_HAK
from htan,thak
where thak.thakcod=htan.thakcod
and htan.htanflgact="N"
group by 1,2;

-----------------------------------
JUMLAH HAK DAN SU SUDAH LINK (GS/SU
-----------------------------------

(1)PERTAHUN YG GS
--------------------------------------------------------
select gsht.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(distinct gsht.htanseq) 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;

(2)PERTAHUN YG SU
--------------------------------------------------------
select paht.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(distinct paht.htanseq) 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;

SQL (1)DAN(2) HASILNYA DIJUMLAHKAN YA...

------------------------------
JUMLAH SU PERTAHUN DAN LUASNYA
------------------------------
select year(gssudat) TAHUN,
count(distinct gssunum) JUMLAH_SU,
sum(gssuare) JUMLAH_LUAS
from gssu
where gssudat is not null
group by 1;

------------------------------
JUMLAH GS PERTAHUN DAN LUASNYA
------------------------------
select year(gssudat) TAHUN,
count(distinct gssunum) JUMLAH_GS,
sum(gssuare) JUMLAH_LUAS
from gssuold
where gssudat is not null
group by 1;