SELECT a.StoreName ,sum(b.TotalAmount)as 销售额 ,sum(b.GoodsCount)as 销售笔数 ,
CASE WHEN sum(c.TotalAmount)>0
THEN (sum(b.TotalAmount)-sum(c.TotalAmount))/sum(c.TotalAmount)
ELSE NULL
END as 销售同比
FROM test1 a left join test2 b on a.StoreID=b.StoreID AND b.BillDate='2014-05-25'
left join test2 c on a.StoreID=c.StoreID AND c.BillDate='2014-05-23'
group by a.StoreName
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货