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

select `date` ,  concat(round(下单人数 / 访问人数*100,1),"%") as  cr
from(
select  date(order_time) as `date`, count(distinct user_id) as "下单人数"
from order_tb 
group by  date(order_time)
)t1

join(

select    date(visit_time)   as `date` ,count(distinct user_id) as "访问人数"
from visit_tb 
where datediff(visit_time,leave_time) =0
 group by   date(visit_time)
)t2  using(`date`)
group by date
order by date