题解 | 统计用户从访问到下单的转化率
统计用户从访问到下单的转化率
https://www.nowcoder.com/practice/eaff8684aed74e208300f2737edbb083
#首先各自找出两个表的访问人数，合成一个新表，进行转换率计算
select a.date, concat(round(mai/kan*100, 1),'%') as cr
from
(select date(o.order_time) as date, count(distinct o.user_id) as mai
from order_tb o
group by date(o.order_time)) a
join
(select date(v.visit_time) as date, count(distinct v.user_id) as kan
from visit_tb v
group by date(v.visit_time)) b
on a.date=b.date
order by date;
