题解 | 统计用户从访问到下单的转化率
统计用户从访问到下单的转化率
https://www.nowcoder.com/practice/eaff8684aed74e208300f2737edbb083
select date, concat(round(100*ord_nums/vis_nums,1),'%') as cr
from (
select date(visit_time) as date , count(distinct v.user_id) vis_nums ,count(distinct o.user_id) ord_nums
from visit_tb v
left join order_tb o on v.user_id = o.user_id and date(order_time) = date(visit_time)
group by date(visit_time)
) t1
投递腾讯云智研发等公司7个岗位
