题解 | 未下单用户登陆渠道统计
未下单用户登陆渠道统计
https://www.nowcoder.com/practice/5090553d7854458987997a5c91c30975
select channel, count(*) cnt from user_info u left join order_log o using (uid) where order_id is null group by channel order by cnt desc, channel limit 1

查看11道真题和解析