题解 | 零食类商品中复购率top3高的商品

-- 1 算零食类商品的各个商品的复购率 2 order by ,limit 3
with tt as(
    select d.product_id, event_time, uid from tb_order_detail d left join tb_order_overall o using(order_id) left join tb_product_info i using(product_id)
    where tag ='零食'
)
-- 求复购的人数目
, tb as(
    select * from tt where event_time >= (select date_sub(max(event_time), interval 89 day) from tb_order_overall)
)
select 
    product_id, 
    round( (count(uid) - count(distinct uid))/count(distinct uid), 3) g
    from tb
    group by 1

    order by 2 desc, 1 asc
    limit 3

题目描述的一团浆糊，垃圾题目，尤其是90天以内的那什么玩意。知识点考的还好。