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