题解 | 未下单用户统计
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
select count(distinct u.uid)-count(distinct o.uid) cnt from user_info u left join order_log o on u.uid = o.uid
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
select count(distinct u.uid)-count(distinct o.uid) cnt from user_info u left join order_log o on u.uid = o.uid
相关推荐