题解 | #统计2021年10月每个退货率不大于0.5的商品各项指标#

select
product_id,
round(sum(if_click)/count(1),3),
round(case sum(if_click) when 0 then 1 else sum(if_cart)/sum(if_click) end,3),
round(case sum(if_cart) when 0 then 1 else sum(if_payment)/sum(if_cart) end,3),
round(case sum(if_payment) when 0 then 1 else sum(if_refund)/sum(if_payment) end,3) refund_rate
from
tb_user_event
where date_format(event_time, "%Y-%m") = '2021-10'
group by product_id
having refund_rate <= 0.5
order by product_id