select wh, 人数=sum([id]), 平均年龄=avg(age), 百分比=cast(sum([id])*100/(select sum(id) from emp) as varchar(10))+'%' from emp group by wh
select a.wh,count(b.*) as howmany,avg(b.age) as avgold,count(b.*)/(select count(1) from emp) as p from ( select distinct wh from emp ) a left join emp b on a.wh=b.wh
select a.wh,count(b.*) as howmany,avg(b.age) as avgold,count(b.*)/(select count(1) from emp) as p from ( select distinct wh from emp ) a left join emp b on a.wh=b.wh group by a.wh
人数=sum([id]),
平均年龄=avg(age),
百分比=cast(sum([id])*100/(select sum(id) from emp) as varchar(10))+'%'
from emp group by wh
from (
select distinct wh from emp
) a left join emp b on a.wh=b.wh
from (
select distinct wh from emp
) a left join emp b on a.wh=b.wh
group by a.wh