题解 | 统计用户从访问到下单的转化率
统计用户从访问到下单的转化率
https://www.nowcoder.com/practice/eaff8684aed74e208300f2737edbb083
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);
够出生