题解 | #统计2021年10月的商品各项指标#
统计2021年10月每个退货率不大于0.5的商品各项指标
https://www.nowcoder.com/practice/cbf582d28b794722becfc680847327be
# 请统计2021年10月每个有展示记录的退货率不大于0.5的商品各项指标
select
product_id,
round(sum(if_click) / count(*), 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
year (event_time) = 2021
and month (event_time) = 10
group by
product_id
having
refund_rate <= 0.5
order by
product_id
投递阿里巴巴集团等公司9个岗位