SQL MENCARI JUMLAH TOTAL PERMOHONAN PEMECAHAN DAN HAKNYA

select inde.masterpk2 KODE_HAK,
thak.thakdes JENIS_HAK,
d301.tindcod KODE_KEGIATAN,
tind.tinddes JENIS_KEGIATAN,
count(distinct d301.d301seq) JUMLAH_PERMOHONAN
from d301,inde,thak,tind
where year(d301.d301dat)=2006
and d301.tindcod in ("03","11","12","27","28","29")
and tind.tindcod=d301.tindcod
and d301.indecod=inde.indecod
and thak.thakcod=inde.masterpk2
group by 1,2,3,4;