with u as( select distinct uid,channel from user_info where uid not in (select uid from order_log)) select channel,count(*) as cnt from u group by channel order by cnt desc,channel limit 1
with u as( select distinct uid,channel from user_info where uid not in (select uid from order_log)) select channel,count(*) as cnt from u group by channel order by cnt desc,channel limit 1