select if (pay_method = '','error',pay_method)
,count(*)
from user_client_log
left join product_info
on user_client_log.product_id = product_info.product_id
where product_name = 'anta'
and step = 'select'
group by 1
order by 2 desc