SQL BT SU DAN NIB 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 NIB
-------------------------------------------
select desaco8,
count(distinct parcnib) Jumlah_NIB
from gspa
group by desaco8;

-------------------------------------------
KETERANGAN :
JUMLAH SU TEKSTUAL HASIL PENJUMLAHAN SQL 2 DAN 3.
JUMLAH SU SPATIAL SQL NO. 4