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