题解 | 未下单用户统计
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
--另一个思路 select count(distinct case when order_id is null then uf.uid end) as cnt from order_log lg right join user_info uf on lg.uid=uf.uid
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
--另一个思路 select count(distinct case when order_id is null then uf.uid end) as cnt from order_log lg right join user_info uf on lg.uid=uf.uid
相关推荐