题解 | 商品销售总额分布
商品销售总额分布
https://www.nowcoder.com/practice/62909494cecd4eab8c2501167e825566
select pay_method,count(*) as numbers
from(
select case when trim(pay_method)='' then 'error' else pay_method end as pay_method
from user_client_log join product_info using(product_id)
where product_name='anta' and step='select'
) temp
group by pay_method
order by numbers desc;
