题解 | 未下单用户统计

未下单用户统计

https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090

select
cast(sum(notorder) as signed) as cnt
from
(select
u.uid,if(o.uid is null,1,0) as notorder
from user_info u 
left join (select distinct uid as uid from order_log) as o on u.uid=o.uid
) as notordernum;

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务