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

SELECT date_b as date,concat(round(100 * count(distinct a.user_id)/count(distinct b.user_id),1),'%') as cr
FROM 
  (SELECT user_id,date(order_time) as date_a
  FROM order_tb)a
right JOIN 
  (SELECT user_id,date(visit_time) as date_b
  FROM visit_tb)b
ON a.user_id = b.user_id
AND a.date_a = b.date_b
GROUP BY date_b
ORDER BY date_b

##right join是必须