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

with t1 as(
select 
    date(order_time) as order_time,
    count(distinct user_id) as order_nums
from order_tb 
group by date(order_time)
),
t2 as(
select 
    date(visit_time) as visit_time,
    count(distinct user_id) as visit_nums
from visit_tb 
group by date(visit_time)
)
select 
    order_time as date,
    concat(round((order_nums/visit_nums)*100,1),'%') as cr 
from t1 inner join t2 on t1.order_time = t2.visit_time
order by order_time