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

select
    ordertime as date,
    concat(round(orderid / visitid*100, 1) ,'%') as cr
from
    (
        select
            count(distinct user_id) as orderid,
            date_format (order_time, '%Y-%m-%d') as ordertime
        from
            order_tb
        group by
            ordertime
    ) as order1
    join (
        select
            count(distinct user_id) as visitid,
            date_format (visit_time, '%Y-%m-%d') as visittime
        from
            visit_tb
        group by
            visittime
    ) as visit1 on order1.ordertime = visit1.visittime
group by
    date
order by
    date