SQL完成销售额指标的商品

销售额完成任务指标的商品
要求每个商品每月卖出一定量
1商品>=21000 2商品>=10000 其余没有要求

订单明细表：order_detail 
字段：order_id sku_id create_date price sku_num

需求：查询连续两个月销售额大于等于销售任务总额的商品

select distinct sku_id from (
    select 
     
     sku_id,months,amount,flg,lead(flg,1,9999) over(partition by sku_id order by months) after_flg
     from (
    
        select 
         sku_id,months,amount
         ,case 
         when sku_id = 1 and amount >= 21000 then 1 
         when sku_id = 1 and amount < 21000 then 0 
         when sku_id = 2 and amount >= 10000 then 1 
         when sku_id = 2 and amount < 10000 then 0 
         when sku_id > 2 and amount > 0 then 1
         when sku_id > 2 and amount = 0 then 0     
         end flg 
         
         from (
            select sku_id, year(create_date)*12 + month(create_date) months, sum(price*sku_num) amount  from order_detail
            group by sku_id, substr(create_date,1,7)
        ) a 
    
    ) b 

) c where flg = after_flg and flg = 1