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

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