题解 | 统计用户从访问到下单的转化率
统计用户从访问到下单的转化率
https://www.nowcoder.com/practice/eaff8684aed74e208300f2737edbb083
with t1 as (
select
date(visit_time) as date,
count(distinct user_id) as day_visit_people
from visit_tb v
group by date(visit_time)
),
t2 as (
select
date(order_time) as date,
count(distinct user_id) as day_order_people
from order_tb o
group by date(order_time)
)
select
t1.date,
concat(round(day_order_people/day_visit_people*100,1),'%') as cr
from t1
left join t2
on t1.date = t2.date
order by date
