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

WITH `buyy` AS(
	SELECT
    DATE(`order_time`) AS `date`,
    count(DISTINCT `user_id`) AS `buy`
    FROM `order_tb`
    GROUP BY DATE(`order_time`)),
    
    `visitt` AS(
    SELECT 
    DATE(`visit_time`) AS `date`,
    count(DISTINCT `user_id`) AS `visit`
    FROM `visit_tb`
    GROUP BY DATE(`visit_time`))
    
SELECT 
	`visitt`.`date`,
    CONCAT(ROUND(COALESCE(`buy`,0)/`visit`*100,1),'%') AS `cr`
    FROM `buyy`
    JOIN `visitt` ON `buyy`.`date`= `visitt`.`date`;