题解 | 统计用户从访问到下单的转化率

with t as(

select a.date, visit_cnt, order_cnt
from (
select date(visit_time) 'date', count(distinct user_id) 'visit_cnt'
from visit_tb
group by date(visit_time)
)b
left join
    (select date(order_time) 'date', count(distinct user_id) 'order_cnt'
    from order_tb 
    group by date(order_time)
    )a 
on a.date = b.date
)


select date, CONCAT(round(order_cnt * 100 / visit_cnt,1),'%')'cr'
from t
order by date asc;

分别计算出 每天的访问人数和 下单人数，最后两个表格进行拼接即可