题解 | 未下单用户统计
未下单用户统计
https://www.nowcoder.com/practice/3433aee5c7824255b2dd2879b30df090
with
t1 as(
select
uid,
order_id
from
user_info left join order_log using(uid)
)
,
t2 as(
select
count(distinct uid)
from
t1
where
order_id is null
)
select * from t2
