select pay_method,count(*) as numbers
from(
    select case when trim(pay_method)='' then 'error' else  pay_method end as pay_method
    from user_client_log join product_info using(product_id)
    where product_name='anta' and step='select'
) temp
group by pay_method
order by numbers desc;