题解 | 未下单用户登陆渠道统计
未下单用户登陆渠道统计
https://www.nowcoder.com/practice/5090553d7854458987997a5c91c30975
with u as(
select distinct uid,channel from user_info
where uid not in (select uid from order_log))
select channel,count(*) as cnt
from u
group by channel
order by cnt desc,channel
limit 1
查看7道真题和解析