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

SELECT 
  DATE(v.visit_time) AS date,
  CONCAT(
    ROUND(
      (COUNT(DISTINCT o.user_id) / COUNT(DISTINCT v.user_id)) * 100, 
      1
    ),
    '%'
  ) AS cr
FROM visit_tb v
LEFT JOIN order_tb o 
  ON v.user_id = o.user_id  -- 按用户关联
  AND DATE(v.visit_time) = DATE(o.order_time)  -- 确保同一天的访问和订单
GROUP BY DATE(v.visit_time);