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

select t1.day as date,
CONCAT(ROUND(od / xd * 100, 1), '%')as cr
from
 (select  DATE_FORMAT(order_time, '%Y-%m-%d')  as day,
count(distinct user_id) as od
 from order_tb
 group by DATE_FORMAT(order_time, '%Y-%m-%d')) t1

join
  (select  DATE_FORMAT(visit_time, '%Y-%m-%d')  as day,
count(distinct user_id) as xd
 from visit_tb
 group by DATE_FORMAT(visit_time, '%Y-%m-%d'))t2

 on t1.day = t2.day