题解 | #统计商品各项指标

# 2021年10月每个有展示记录的退货率不大于0.5的商品各项指标
# 字段:商品id/ctr/加购率/支付率/退款率 = 退款/支付

# 表一：获取退款率不大于0.5的名单 10月份
select product_id, 
round(sum(if_click) / count(if_click),3) as ctr,
round(sum(if_cart) / sum(if_click),3) as cart_rate, # 加购率
round(sum(if_payment)/ sum(if_cart),3) as payment_rate,# 支付率
round(sum(if_refund)/sum(if_payment),3) as refund_rate
from tb_user_event
where year(event_time) = 2021 and month(event_time) = 10
group by product_id
having sum(if_refund)/sum(if_payment)<=0.5
order by product_id asc