查询概率的sql语句

select aaa.name as '乡镇',count(aa) as '总数',sum(aa) as '完整数', Convert(decimal(18,2), (sum(aa)+0.0)/count(aa)*100) as '完整率（%）' from 			
(			
select dp.Name,					
case when (	WorkUnit is not null and WorkUnit!=''	)then 1 else 0 end as aa			
from PersonInfo p 				
left join District d on d.Id=p.DistrictId			
left join District dp on dp.Id=d.ParentId			
where  p.Isdelete = 0 		
) aaa			
group by aaa.Name			
order by aaa.Name