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

SELECT
    a.date,
    CONCAT (ROUND(od / nd * 100, 1), '%') AS cr
FROM
    (
        SELECT
            DATE (o.order_time) AS date,
            COUNT(DISTINCT o.user_id) as od
        FROM
            order_tb AS o
        GROUP BY
            DATE (o.order_time)
    ) AS a
    JOIN (
        SELECT
            DATE (v.visit_time) AS date,
            COUNT(DISTINCT v.user_id) AS nd
        FROM
            visit_tb AS v
        GROUP BY
            DATE (v.visit_time)
    ) AS b ON a.date = b.date