求一个sql语句或者逻辑、思路
SELECT p.IdNumber 证件号,p.Name 姓名,case when COUNT(pc.Id) >0 then
CASE WHEN SUM(CAST(IsValidity AS INT))>=1 THEN '1' ELSE '2' END
ELSE '3' end AS 单位地址
from PersonContacts pc
inner join BaseCodes bc on bc.Id = pc.TypeId
inner join PersonAccounts pa ON pa.Id = pc.PersonAccountId
inner join Persons p on p.Id = pa.PersonId
where bc.CodeValue = '单位地址' AND p.name='鲍' AND p.IdNumber='332603196402284999'
group BY p.Name,p.IdNumber
问题:where的三个条件是查不出来数据的,我的目标是输出 |证件号|姓名|3| 来表示无数据,但是现在却是进不去else里,输出为空的,求解答