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