select nsb.no_kenal, count(*) Duplikasi from bks_core.nasabah nsb
where nsb.jen_nas = '0' and EXISTS (select * from bks_core.kredit krd where nsb.no_nas = krd.no_nas and nsb.kd_cab = krd.kd_cab_nas)
GROUP BY nsb.no_kenal
having Duplikasi>1