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

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