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