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