select 部门, sum(员工日销售金额) as 销售总额 sum(员工日销售金额)/count(distinct 部门员工姓名) as 部门人均销售总额, convert(varchar(7),日期,120) as 年月 from 一个表 group by 部门,convert(varchar(7),日期,120)
select 部门, sum(员工日销售金额) as 销售总额, count(distinct 部门员工姓名) as 部门人数, sum(员工日销售金额)/count(distinct 部门员工姓名) as 部门人均销售总额, convert(varchar(7),日期,120) as 年月 from 一个表 group by 部门,convert(varchar(7),日期,120)
sum(员工日销售金额)/count(distinct 部门员工姓名) as 部门人均销售总额 ------------------------------------------------------------------------------- 改成: 1.0*sum(员工日销售金额)/count(distinct 部门员工姓名) as 部门人均销售总额
sum(员工日销售金额) as 销售总额
sum(员工日销售金额)/count(distinct 部门员工姓名) as 部门人均销售总额,
convert(varchar(7),日期,120) as 年月
from 一个表
group by 部门,convert(varchar(7),日期,120)
sum(员工日销售金额) as 销售总额,
count(distinct 部门员工姓名) as 部门人数,
sum(员工日销售金额)/count(distinct 部门员工姓名) as 部门人均销售总额,
convert(varchar(7),日期,120) as 年月
from 一个表
group by 部门,convert(varchar(7),日期,120)
-------------------------------------------------------------------------------
改成:
1.0*sum(员工日销售金额)/count(distinct 部门员工姓名) as 部门人均销售总额