SQL BT SU GU DAN SK JUMLAHNYA

1) JUMLAH BUKU TANAH
-------------------------------------------
select desaco8,
thakcod,
count(distinct htanseq) Jumlah_Hak
from htan
group by desaco8,thakcod;
2) JUMLAH SU
-------------------------------------------
select desaco8,
count(distinct gssunum) Jumlah_SU
from gssu
group by desaco8;
3) JUMLAH GS
-------------------------------------------
select desaco8,
count(distinct gssunum) Jumlah_GS
from gssuold
group by desaco8;
4) JUMLAH GAMBAR UKUR
-------------------------------------------
select desaco8,
count(distinct gauknum) Jumlah_GU
from gauk
group by desaco8;
5) JUMLAH SK
-------------------------------------------
select count(*) from decr
where decr.decrisudat is not null
and decr.decrexpdat is not null;
-------------------------------------------
KETERANGAN :
JUMLAH SU TEKSTUAL HASIL PENJUMLAHAN SQL 2 DAN 3.