题解 | #统计2021年10月每个退货率不大于0.5

select product_id,
        round(sum(if_click)/count(1),3) ctr,
        round(sum(if_cart)/sum(if_click),3) cart_rate,
        round(sum(if_payment)/sum(if_cart),3) payment_rate,
        round(sum(if_refund)/sum(if_payment),3) refund_rate
from
    tb_user_event
where
    date_format(event_time,"%Y%m")="202110"
group by product_id,date_format(event_time,"%Y%m")
order by product_id