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

SELECT DATE(visit_time) AS date, CONCAT(ROUND(COUNT(DISTINCT order_tb.user_id)/COUNT(DISTINCT visit_tb.user_id)*100,1),'%') AS cr
FROM visit_tb
LEFT JOIN order_tb 
ON visit_tb.user_id = order_tb.user_id AND order_time BETWEEN visit_time AND leave_time
GROUP BY date
ORDER BY date;

注意：

1. 两表的联结方式
2. 数字转换成百分比时，*100放在什么位置
3. 日期选择哪一列
4. 订单人数和访问人数去不去重