select case when u.pay_method='' then 'error' else u.pay_method end as pay_method,count(distinct u.trace_id) as rk
from user_client_log u join product_info p on u.product_id=p.product_id
where u.step='select' and p.product_name='anta'
group by u.pay_method
order by rk desc