题解 | 未下单用户统计
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
select
count(*) as cnt
from user_info u
where not exists (
select 1 from order_log o
where u.uid = o.uid
)
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
select
count(*) as cnt
from user_info u
where not exists (
select 1 from order_log o
where u.uid = o.uid
)
相关推荐