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

with A as(
    select DATE(order_time) as date,count(distinct user_id) as o_users
    from order_tb
    group by DATE(order_time)
),
B as(
    select DATE(visit_time) as date,count(distinct user_id) as v_users
    from visit_tb
    group by DATE(visit_time)
)

select B.date,concat(round(A.o_users/B.v_users*100,1),'%') as cr
from B
left join A on A.date = B.date