select
channel
,cnt
from(
    select
    channel
    ,count(*) cnt
    ,rank()over(order by count(*) desc, channel) rk
    from user_info
    where uid not in (select uid from order_log)
    group by channel
) t
where rk = 1