题解 | 未下单用户登陆渠道统计
未下单用户登陆渠道统计
https://www.nowcoder.com/practice/5090553d7854458987997a5c91c30975
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;