题解 | #统计10月每个退货率不大于0.5的商品各项指标#
统计2021年10月每个退货率不大于0.5的商品各项指标
https://www.nowcoder.com/practice/cbf582d28b794722becfc680847327be
-- 2021.10 有展示记录 退货率不大于0.5 select product_id,round(sum(if_click)/count(uid),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) payment_rate from tb_user_event where substr(event_time,1,7) = '2021-10' group by product_id order by product_id ASC
投递恒生电子股份有限公司等公司7个岗位 >