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