题解 | 未下单用户登陆渠道统计

select
channel,count(*) as cnt
from user_info u
left join (select distinct uid as uid from order_log) as o on u.uid=o.uid
where o.uid is null
group by channel
order by channel 
limit 1;