统计每日商品1和商品2销量的差值 题目需求 从订单明细表(order_detail)中统计每天商品1和商品2销量(件数)的差值(商品1销量-商品2销量),期望结果如下: create_datediff2020-10-08-242021-09-272…… 代码实现 select create_date, (sum(if(sku_id='1', sku_num, 0)) - sum(if(sku_id='2', sku_num, 0))) diff from order_detail where sku_id in ('1', '2') group by create_date;