with
t1 as(
    select
        uid,
        channel
    from
        user_info left join order_log using(uid)
    where
        order_id is null
)

select
    channel,
    count(uid) as cnt
from
    t1
group by
    channel
order by
    cnt desc,
    channel
limit
    1