题解 | 商品销售总额分布

select
    if (u.pay_method = '', 'error', u.pay_method),
    count(1) as c
from
    user_client_log u,
    product_info p
where
    u.product_id = p.product_id
    and p.product_name = 'anta'
    and u.step = 'select'
group by
    u.pay_method
order by
    c desc