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

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