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

select 
  visit_date as date,
  concat(round(count(order_date)/count(visit_date)*100,1),'%') as cr
from (
  (
    select distinct
      user_id,
      date(visit_time) as visit_date
    from 
      visit_tb
  ) as a
left join 
  (
    select distinct
      user_id,
      date(order_time) as order_date
    from
      order_tb
  ) as b 
on
  a.user_id=b.user_id and a.visit_date=b.order_date
 )
group by 
  date
order by 
  date;