题解 | 统计用户从访问到下单的转化率
统计用户从访问到下单的转化率
https://www.nowcoder.com/practice/eaff8684aed74e208300f2737edbb083
with c as( select order_date,count(*) as order_count from( select user_id,date(order_time) as order_date from order_tb group by user_id,order_date) as a group by order_date), d as ( select visit_date,count(*) as visit_count from( select user_id,date(visit_time) as visit_date from visit_tb group by user_id,visit_date) as b group by visit_date) select order_date as date ,concat(round((order_count/visit_count)*100,1),'%') as cr from c join d on c.order_date = d.visit_date order by date
查看46道真题和解析