题解 | 未下单用户登陆渠道统计

SELECT
    b.channel,
    COUNT(DISTINCT b.uid) AS cnt
FROM order_log AS a
RIGHT JOIN user_info AS b
    ON a.uid = b.uid
WHERE a.uid IS NULL
GROUP BY b.channel
ORDER BY CNT DESC,b.channel
LIMIT 1;