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

select
        date(vtb.visit_time) as date,
        concat(round(count(distinct otb.user_id) / count(distinct vtb.user_id) * 100,1),'%') as cr
from 
        visit_tb as vtb
left join 
        order_tb as otb
on 
        vtb.user_id = otb.user_id
and 
        date(vtb.visit_time) = date(otb.order_time)
group by
        date(vtb.visit_time)