SQL每件商品每天的销售额情况

订单表：order_detail
字段：order_id(订单ID),sku_id（商品ID）,create_date（下单日期），price（商品单价）, sku_num（下单数量）

需求：计算'2021-09-27' 至 '2021-10-03' 这周内每件商品每天的销售额情况

 1 select 
 2  
 3  sku_id
 4  ,sum(if(create_date = '2021-09-27',sam,0)) monday
 5   ,sum(if(create_date = '2021-09-28',sam,0)) tuesday 
 6    ,sum(if(create_date = '2021-09-29',sam,0)) wednesday
 7     ,sum(if(create_date = '2021-09-30',sam,0)) thursday
 8      ,sum(if(create_date = '2021-10-01',sam,0)) firday
 9       ,sum(if(create_date = '2021-10-02',sam,0)) saturday
10        ,sum(if(create_date = '2021-10-03',sam,0)) sunday
11   
12  
13  from (
14     select 
15      sku_id,create_date,sum(price*sku_num) sam
16      
17      from order_detail where create_date between '2021-09-27' and '2021-10-03' 
18     group by sku_id,create_date
19 ) a group by sku_id

posted on 2025-06-21 18:21 北京的小乔阅读(15) 评论(0) 收藏举报