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

WITH visit_user AS(
	SELECT
		COUNT(DISTINCT user_id) AS visit_num,
        DATE(visit_time) AS date
	FROM visit_tb
    GROUP BY DATE(visit_time)
),
order_user AS (
	SELECT 
		COUNT(DISTINCT user_id) AS order_num,
        DATE(order_time) AS date
	FROM order_tb
    GROUP BY DATE(order_time)
)

SELECT
	ou.date,
    CONCAT(ROUND(order_num/visit_num*100,1),'%') AS cr
FROM visit_user vu
LEFT JOIN order_user ou USING (date)