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

select t1.order_date as date, concat(round(cnt1*100/cnt2, 1), "%") as cr
from (
    select count(distinct user_id) as cnt1, date(order_time) as order_date
    from order_tb
    group by date(order_time)
) t1
join (
    select count(distinct user_id) cnt2, date(visit_time) as visit_date
    from visit_tb
    group by date(visit_time)
) t2
on t1.order_date = t2.visit_date
order by t1.order_date asc