题解 | 统计2021年10月每个退货率不大于0.5的商品各项指标
统计2021年10月每个退货率不大于0.5的商品各项指标
https://www.nowcoder.com/practice/cbf582d28b794722becfc680847327be
with a as(
select
product_id,
count(*) as showtimes,
sum(if_click) as click,
sum(if_cart) as cart,
sum(if_payment) as payment,
sum(if_refund) as refund
from tb_user_event
where date_format(event_time,'%Y-%m')='2021-10'
group by product_id
)
select
product_id,
round(click/showtimes,3) as ctr,
round(cart/click,3) as cart_rate,
round(payment/cart,3) as payment_rate,
round(refund/payment,3) as refund_rate
from a
group by product_id
order by product_id
;
查看7道真题和解析