统计2021年10月每个退货率不大于0.5的商品各项指标
统计2021年10月每个退货率不大于0.5的商品各项指标
https://www.nowcoder.com/practice/cbf582d28b794722becfc680847327be
#13:24-13:32
select
product_id,
round(sum(if_click) / count(event_time), 3) ctr,
round(
if (
sum(if_click) = 0,
0,
sum(if_cart) / sum(if_click)
),
3
) cart_rate,
round(
if (
sum(if_cart) = 0,
0,
sum(if_payment) / sum(if_cart)
),
3
) payment_rate,
round(
if (
sum(if_payment) = 0,
0,
sum(if_refund) / sum(if_payment)
),
3
) refund_rate
from
tb_user_event
where
date_format (event_time, '%Y-%m') = '2021-10'
group by
product_id
having
round(
if (
sum(if_payment) = 0,
0,
sum(if_refund) / sum(if_payment)
),
3
) <= 0.5
order by
product_id
查看45道真题和解析
