题解 | 统计用户从访问到下单的转化率

#每日下订单数
select date(order_time) as time1,count(distinct user_id) as c1
from order_tb
group by date(order_time)
#每日访问数
select date(visit_time) as time2,count(distinct user_id) as c2
FROM visit_tb
group by date(visit_time)
#转化率
select time1 as date,concat(round((c1/c2)*100,1),'%') as cr
from 
(select date(order_time) as time1,count(distinct user_id) as c1
from order_tb
group by date(order_time)) as day_order join
(select date(visit_time) as time2,count(distinct user_id) as c2
FROM visit_tb
group by date(visit_time)) as day_visit
on day_order.time1 = day_visit.time2
group by time1