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

全部评论

相关推荐

05-09 12:23
已编辑
华南理工大学 Java
野猪不是猪🐗:给他装的,双九+有实习的能看的上这种厂我直接吃⑨✌们拿它练练面试愣是给他整出幻觉了
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务