题解 | 商品销售总额分布

select if(pay_method != "",pay_method,"error"),count(*) num
from user_client_log ucl
where product_id = (select product_id from product_info
                    where product_name = "anta")
      and step = "select"
group by pay_method
order by num desc

注意不是null而是空字符串