create table familyInfo(id int,regionCode int)
insert into familyInfo values(1,1000)
go
create table familyPerson(id int,familyInfoId int,sex int)
insert into familyPerson values(1,1,0)
insert into familyPerson values(2,1,1)
go
select a.regionCode 区域,b.男人数 , b.女人数 from familyInfo a,
(
select familyInfoId,
sum(case when sex = 0 then 1 else 0 end) '男人数',
sum(case when sex = 1 then 1 else 0 end) '女人数'
from familyPerson
group by familyInfoId
) b
where a.id = b.familyInfoId
drop table familyInfo,familyPerson