select 月份, sum (case when 销售人员='姓名1' then 销售数量*产品单价 else 0 end) as '姓名1销售额', sum (case when 销售人员='姓名2' then 销售数量*产品单价 else 0 end) as '姓名2销售额', sum (case when 销售人员='姓名3' then 销售数量*产品单价 else 0 end) as '姓名3销售额' from 表格 group by 月份,销售人员