select
case when pay_method="" then "error" else pay_method end as py,
count(pay_method) as cnt
from user_client_log lg left join product_info pf on 
lg.product_id=pf.product_id
where
step="select"
and 
product_name="anta"
group by pay_method