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

SELECT
    vu.date,
    CONCAT(ROUND(ou.num/vu.num*100,1),'%') AS cr
FROM
#算每天访问的人数
(SELECT
    DATE(visit_time) AS date,
    COUNT(DISTINCT user_id) AS num
FROM
    visit_tb
GROUP BY
    DATE(visit_time)) AS vu
INNER JOIN
#算每天下单的人数
(SELECT
    DATE(order_time) AS date,
    COUNT(DISTINCT user_id) AS num
FROM
    order_tb
GROUP BY
    DATE(order_time)) AS ou
ON vu.date=ou.date
ORDER BY
    vu.date;