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

select order_time as date,
concat(round(round(order_number/count(distinct user_id),3)*100,1),'%') as cr
from
    (select order_time,
    count(distinct user_id) as order_number
    from 
        (select user_id,
        date(order_time) as order_time
        from
        order_tb
        ) a
    group by order_time) b
join 
    (select
    user_id,
    date(visit_time) as visit_time,
    date(leave_time) as leave_time
    from
    visit_tb
    where date(visit_time) = date(leave_time)) c
on b.order_time = c.visit_time
group by order_time