declare @bl int
select @bl=count(1) from b

select id,count(w) fc
from (
select a1.w,a1.ID
from A a1
left join b on a1.w=b.w
where b.w is not null
) a
having count(w)>=@bl