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

SELECT 
    date1 AS date,
    CONCAT(ROUND((a/b)*100,1),'%') AS cr
FROM(
    SELECT
        DATE(order_time) AS date1,
        COUNT(DISTINCT user_id) AS a
    FROM order_tb
    GROUP BY date1) A
JOIN (
    SELECT
        DATE(visit_time) AS date2,
        COUNT(DISTINCT user_id) AS b
    FROM visit_tb
    GROUP BY date2) B
ON A.date1 = B.date2

要对用户去重，DISTINT user_id