答案:
select coalesce(Date,'合计') Date,
sum(case when Type = '服装鞋包' then Sale else 0 end) '服装鞋包',
sum(case when Type = '日用百货' then Sale else 0 end) '日用百货',
sum(Sale) '销售总额'
from SalesRecord group by Date with rollup