题解 | 商品销售总额分布
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