select if(pay_method='','error',pay_method) pay_method,
count(*) cnt
from user_client_log u join product_info p using(product_id)
where product_name='anta' and step='select'
group by pay_method
order by cnt desc

本题不筛选排出pay_method为空，而是将他作为null