题解 | 未下单用户统计
未下单用户统计
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;
