题解 | 统计用户从访问到下单的转化率
统计用户从访问到下单的转化率
https://www.nowcoder.com/practice/eaff8684aed74e208300f2737edbb083
select date1 as date ,concat(round(uv2/uv1*100,1),'%') as cr from(select date(visit_time) as date1 ,count(distinct user_id) as uv1 from visit_tb group by 1) t1 left join (select date(order_time) as date2 ,count(distinct user_id) as uv2 from order_tb group by 1) t2 on t1.date1 = t2.date2 order by 1
基本思路：将两张表改变成日期粒度并进行连接
辅导员肯定不能同意，不然你出事了，他要承担责任。但是，脚和脑子都长在你自己身上，使用它还需要向辅导员报告么？
辅导员必须按流程拒绝你，然后你拿出成年人的态度，做自己的选择。