select bct_cde, count(*) as count from CIRLBL_R
where pub_cde = 'WHO' and isu_dte = '2019-05-20'
group by bct_cde

select * from CIRLBL_R
where pub_cde = 'WHO'
and isu_dte = '2019-05-20'
and sub_ref not in (select sub_ref from AdvDbPACF_TST.dbo.CIRLBL_R where pub_cde = 'WHO' and isu_dte = '2019-05-20')