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

select left(t1.order_time, 10) as date,
       concat(round(count(distinct t1.user_id)/count(distinct t2.user_id) * 100, 1), '%') as cr
  from order_tb t1
 inner join visit_tb t2
    on left(t1.order_time, 10) = left(t2.visit_time, 10)
 group by left(t1.order_time, 10)
 order by left(t1.order_time, 10)