题解 | 统计用户从访问到下单的转化率
统计用户从访问到下单的转化率
https://www.nowcoder.com/practice/eaff8684aed74e208300f2737edbb083
select date(visit_time) date ,concat(ROUND(count(distinct order_tb.user_id)/count(distinct visit_tb.user_id)*100,1),'%') cr from order_tb right join visit_tb on order_tb.user_id = visit_tb.user_id and date(visit_time) = date(order_time) group by 1 order by date
查看15道真题和解析