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