题解 | 未下单用户登陆渠道统计
未下单用户登陆渠道统计
https://www.nowcoder.com/practice/5090553d7854458987997a5c91c30975
select
channel
,cnt
from(
select
channel
,count(*) cnt
,rank()over(order by count(*) desc, channel) rk
from user_info
where uid not in (select uid from order_log)
group by channel
) t
where rk = 1
OPPO公司福利 1082人发布
查看11道真题和解析