题解 | 统计用户从访问到下单的转化率
统计用户从访问到下单的转化率
https://www.nowcoder.com/practice/eaff8684aed74e208300f2737edbb083
select date(visit_time) as date, concat(round(100*count(distinct o.user_id)/count(distinct v.user_id),1),'%') as cr from visit_tb v left join order_tb o on date(v.visit_time) = date(o.order_time) group by 1 order by 1 ;
