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

select date
,concat(round(订单人数/访问人数*100,1),'%') cr  
from
(
	select date_format(order_time,'%Y-%m-%d') date
	,count(distinct user_id) 订单人数
	from order_tb
	group by 1
)a
join
(
	select date_format(visit_time,'%Y-%m-%d') visit_date
	,count(distinct user_id) 访问人数
	from visit_tb
	group by 1
)b 
on a.date = b.visit_date 
order by date